Hi Team,
In my Dot Net c# scheduler I am running this following query,
using (CustomCommand getPDInboxCount = new CustomCommand()) { getPDInboxCount.CommandType = System.Data.CommandType.StoredProcedure; getPDInboxCount.CommandText = "GetUserInboxCount"; getPDInboxCount.AddParameterWithValue("UserID", dtUsers["UserID"].ToString());
getPDInboxCount.AddParameterWithValue("DepartmentID", dtUsers["DepartmentID"].ToString());
getPDInboxCount.AddParameterWithValue("UserRoleID", dtUsers["RoleID"].ToString());
Logs.LoggingIntoText("[" + DateTime.Now.ToString() + "] START JOB GetUserInboxCount. " + DBDataAccess.ExecuteScalar(getPDInboxCount) + "", "GetUserInboxCount", Logs.LogType.Information, Logs.LogFor.Scheduler);
inboxCount = Conver ...
Go to the complete details ...