public List <RegionsVM> GetDriveTesterSitesFrmomTable(DataTable dtTestersites)
{
List <RegionsVM> lstSites = new List <RegionsVM>();
if (dtTestersites.Rows.Count > 0)
{
RegionsVM loSite;
for (int i = 0; i < dtTestersites.Rows.Count; i++)
{
loSite = new RegionsVM();
loSite.ID = Convert.ToInt64(dtTestersites.Rows[i]["TesterId"]);
loSite.RegionName = dtTestersites.Rows[i]["TesterName"].ToString();
loSite.TesterImage = dtTestersites.Rows[i]["Picture"].ToString();
loSite.TotalSites = Convert.ToInt32(dtTestersites.Rows[i]["TesterTotalSites"]);
loSite.PendingSites = Convert.ToInt32(dtTestersites.Rows[i]["TesterPendingSites"]);
loSite.InProcessSites = Convert.ToInt32(dtTestersites.Rows[i]["TesterInProcessSites"]);
loSite.CompletedSites = Convert.ToInt32(dtTestersites.Rows[i]["TesterCompletedSites"]);
loSite.DriveCompleted = Convert.ToInt32(dtTestersites.Rows[i]["TesterDriveCompletedSites"]);
loSite.PendingWithIssues = Convert.ToInt32(dtTestersites.Rows[i]["TesterPendingWithIssuesSites"]);
loSite.InProgress = Convert.ToInt32(dtTestersites.Rows[i]["TesterInProgress"]);
loSite.ReportSubmited = Convert.ToInt32(dtTestersites.Rows[i]["TesterReportSubmitted"]);
lstSites.Add(loSite);
}
}
return(lstSites);
}
public List <RegionsVM> GetRegionalSitesFromTable(DataTable TotalSites)
{
List <RegionsVM> lstSites = new List <RegionsVM>();
if (TotalSites.Rows.Count > 0)
{
RegionsVM loSite;
for (int i = 0; i < TotalSites.Rows.Count; i++)
{
loSite = new RegionsVM();
loSite.ID = Convert.ToInt32(TotalSites.Rows[i]["RegionId"]);
loSite.RegionName = TotalSites.Rows[i]["Region"].ToString();
loSite.TotalSites = Convert.ToInt32(TotalSites.Rows[i]["RegionTotalSites"]);
loSite.PendingSites = Convert.ToInt32(TotalSites.Rows[i]["RegionPendingSites"]);
loSite.InProcessSites = Convert.ToInt32(TotalSites.Rows[i]["RegionInProcessSites"]);
loSite.CompletedSites = Convert.ToInt32(TotalSites.Rows[i]["RegionCompletedSites"]);
loSite.DriveCompleted = Convert.ToInt32(TotalSites.Rows[i]["RegionDriveCompletedSites"]);
loSite.PendingWithIssues = Convert.ToInt32(TotalSites.Rows[i]["RegionPendingWithIssuesSites"]);
loSite.InProgress = Convert.ToInt32(TotalSites.Rows[i]["RegionInProgress"]);
loSite.ReportSubmited = Convert.ToInt32(TotalSites.Rows[i]["RegionReportSubmitted"]);
lstSites.Add(loSite);
}
}
return(lstSites);
}
public List <RegionsVM> GetPartialDriveTesterSites(string ParentFilter, string ChildFilter, DateTime StartDate, DateTime EndDate, string RegionFilter, Int64 UserId, Int64 FilterValue, string FilterType2, string FilterValue2)
{
List <RegionsVM> lstSites = new List <RegionsVM>();
try
{
DashboardDL db = new DashboardDL();
DataTable dtTestersites = db.GetPartialRegionalSites(ParentFilter, ChildFilter, StartDate, EndDate, RegionFilter, UserId, FilterValue, FilterType2, FilterValue2);
if (dtTestersites.Rows.Count > 0)
{
RegionsVM loSite;
for (int i = 0; i < dtTestersites.Rows.Count; i++)
{
loSite = new RegionsVM();
loSite.ID = Convert.ToInt64(dtTestersites.Rows[i]["TesterId"]);
loSite.RegionName = dtTestersites.Rows[i]["TesterName"].ToString();
loSite.TesterImage = dtTestersites.Rows[i]["Picture"].ToString();
loSite.TotalSites = Convert.ToInt32(dtTestersites.Rows[i]["TesterTotalSites"]);
loSite.PendingSites = Convert.ToInt32(dtTestersites.Rows[i]["TesterPendingSites"]);
loSite.InProcessSites = Convert.ToInt32(dtTestersites.Rows[i]["TesterInProcessSites"]);
loSite.CompletedSites = Convert.ToInt32(dtTestersites.Rows[i]["TesterCompletedSites"]);
loSite.DriveCompleted = Convert.ToInt32(dtTestersites.Rows[i]["TesterDriveCompletedSites"]);
loSite.PendingWithIssues = Convert.ToInt32(dtTestersites.Rows[i]["TesterPendingWithIssuesSites"]);
loSite.InProgress = Convert.ToInt32(dtTestersites.Rows[i]["TesterInProgress"]);
loSite.ReportSubmited = Convert.ToInt32(dtTestersites.Rows[i]["TesterReportSubmitted"]);
lstSites.Add(loSite);
}
}
return(lstSites);
}
catch (Exception)
{
}
return(lstSites);
}
public List <RegionsVM> GetPartialRegionalSites(string ParentFilter, string ChildFilter, DateTime StartDate, DateTime EndDate, string RegionFilter, Int64 UserId, Int64 FilterValue, string FilterType2, string FilterValue2)
{
List <RegionsVM> lstRegions = new List <RegionsVM>();
try
{
DashboardDL db = new DashboardDL();
DataTable TotalSites = db.GetPartialRegionalSites(ParentFilter, ChildFilter, StartDate, EndDate, RegionFilter, UserId, FilterValue, FilterType2, FilterValue2);
if (TotalSites.Rows.Count > 0)
{
RegionsVM loRegion;
for (int i = 0; i < TotalSites.Rows.Count; i++)
{
loRegion = new RegionsVM();
loRegion.RegionName = TotalSites.Rows[i]["Region"].ToString();
loRegion.ID = Convert.ToInt64(TotalSites.Rows[i]["RegionId"].ToString());
loRegion.TotalSites = Convert.ToInt32(TotalSites.Rows[i]["RegionTotalSites"]);
loRegion.PendingSites = Convert.ToInt32(TotalSites.Rows[i]["RegionPendingSites"]);
loRegion.InProcessSites = Convert.ToInt32(TotalSites.Rows[i]["RegionInProcessSites"]);
loRegion.CompletedSites = Convert.ToInt32(TotalSites.Rows[i]["RegionCompletedSites"]);
loRegion.DriveCompleted = Convert.ToInt32(TotalSites.Rows[i]["RegionDriveCompletedSites"]);
loRegion.PendingWithIssues = Convert.ToInt32(TotalSites.Rows[i]["RegionPendingWithIssuesSites"]);
loRegion.InProgress = Convert.ToInt32(TotalSites.Rows[i]["RegionInProgress"]);
loRegion.ReportSubmited = Convert.ToInt32(TotalSites.Rows[i]["RegionReportSubmitted"]);
lstRegions.Add(loRegion);
}
}
return(lstRegions);
}
catch (Exception)
{
}
return(lstRegions);
}
