Posted on: 10/9/2015 5:16:24 PM | Views : 1210

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 ...