private int PeriodicReportCountUser(int UserId)
{
int OrgID = UserContext.UserData.OrgID;
BusinessServices.User user = new BusinessServices.User();
DataTable dtUser = user.GetUser(UserId);
String Username = dtUser.Rows[0]["UserName"].ToString();
string connectionString = ConfigurationSettings.AppSettings["ConnectionString"] + "password="******"password"] + ";";
PeriodicReportListDataContext prl = new PeriodicReportListDataContext(connectionString);
ISingleResult <prcGetPeriodicReportListOnInactivateUserResult> result = prl.prcGetPeriodicReportListOnInactivateUser(OrgID, Username);
var query = from pr in result.AsQueryable <prcGetPeriodicReportListOnInactivateUserResult>() select pr;
return(query.Count <prcGetPeriodicReportListOnInactivateUserResult>());
}
private int SelectCountUsers()
{
int OrgID = UserContext.UserData.OrgID;
List <string> inactivatedUsernames = (List <string>)Session["InactivatedUsernames"];
List <prcGetPeriodicReportListOnInactivateUserResult> InactiveSchedules = new List <prcGetPeriodicReportListOnInactivateUserResult>();
string connectionString = ConfigurationSettings.AppSettings["ConnectionString"] + "password="******"password"] + ";";
PeriodicReportListDataContext prl = new PeriodicReportListDataContext(connectionString);
foreach (string username in inactivatedUsernames)
{
ISingleResult <prcGetPeriodicReportListOnInactivateUserResult> result = prl.prcGetPeriodicReportListOnInactivateUser(OrgID, username);
var qry = from pr in result.AsQueryable <prcGetPeriodicReportListOnInactivateUserResult>() select pr;
InactiveSchedules.AddRange(qry.ToList <prcGetPeriodicReportListOnInactivateUserResult>());
}
var query = InactiveSchedules.AsQueryable <prcGetPeriodicReportListOnInactivateUserResult>();
return(query.Count <prcGetPeriodicReportListOnInactivateUserResult>());
}
