public static List <tbl_UnassignedTickets> CaseTableDataForToday()
{
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
List <tbl_UnassignedTickets> list = objdata.GetCaseStatusDataWithFilter(DateTime.Today, DateTime.Today, "");
return(list);
}
public static List <string> GetCaseReadyForAction()
{
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
List <string> cList = objdata.GetCaseReadyForAction();
return(cList);
}
public static List <string> GetRoutingPortalForToday()
{
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
List <string> cList = objdata.GetRoutingPortalGraph(DateTime.Today, DateTime.Today);
cList.Add(DateTime.Today.ToString("dd-MMM-yyyy") + " till date.");
return(cList);
}
public static void MarkRecordsAsInActive(string Id)
{
try
{
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
objdata.MarkReconciliationRecordInActive(Id);
}
catch (Exception ex) { throw ex; }
}
public static void MarkAllRecordsAsInActive()
{
try
{
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
objdata.MarkAllReconciliationDataInActive();
}
catch (Exception ex) { throw ex; }
}
public static List <string> CaseForToday()
{
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
List <string> cList = objdata.GetCaseStatusData(DateTime.Today, DateTime.Today);
cList = getpercentagefigure(cList);
cList.Add(DateTime.Today.ToString("dd-MMM-yyyy") + " till date.");
return(cList);
}
public static void ReconsiledReport()
{
try
{
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
List <string> Ids = objdata.GetRecordIdForReconsiliation();
string Ids_Str = string.Join(",", Ids);
objdata.MarkReconciliationRecordsInActive_IdsList(Ids_Str);
}
catch (Exception ex) { throw ex; }
}
public static List <tbl_UnassignedTickets> CaseDataTableOnFilter(string startdate, string enddate, string filter)
{
DateTime Strtday = DateTime.Today, EndDt = DateTime.Today;
if (!string.IsNullOrEmpty(startdate) && !string.IsNullOrEmpty(enddate))
{
Strtday = DateTime.Parse(startdate);
EndDt = DateTime.Parse(enddate);
}
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
List <tbl_UnassignedTickets> list = objdata.GetCaseStatusDataWithFilter(Strtday, EndDt, filter);
return(list);
}
public static List <string> RoutingPortaOnFilter(string startdate, string enddate)
{
DateTime Strtday = DateTime.Today, EndDt = DateTime.Today;
if (!string.IsNullOrEmpty(startdate) && !string.IsNullOrEmpty(enddate))
{
Strtday = DateTime.Parse(startdate);
EndDt = DateTime.Parse(enddate);
}
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
List <string> cList = objdata.GetRoutingPortalGraph(Strtday, EndDt);
cList.Add(startdate + " to " + enddate + ".");
return(cList);
}
public static List <string> CaseDataOnFilter(string startdate, string enddate)
{
DateTime Strtday = DateTime.Today, EndDt = DateTime.Today;
if (!string.IsNullOrEmpty(startdate) && !string.IsNullOrEmpty(enddate))
{
Strtday = DateTime.Parse(startdate);
EndDt = DateTime.Parse(enddate);
}
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
List <string> cList = objdata.GetCaseStatusData(Strtday, EndDt);
cList = getpercentagefigure(cList);
if (string.IsNullOrEmpty(startdate) || string.IsNullOrEmpty(enddate))
{
cList.Add(DateTime.Today.ToString("dd-MMM-yyyy") + " till date.");
}
else
{
cList.Add(startdate + " to " + enddate);
}
return(cList);
}
public static void AddRow_NonCustom_GLReconciliationTable(NonCustom_GLReconciliationTable obj)
{
NonCustom_GLReconciliationTable addObj = new NonCustom_GLReconciliationTable();
if (obj != null)
{
CBDB db = new CBDB();
CaseStatisticsDataLayer objdata = new CaseStatisticsDataLayer();
addObj.ValueDate = obj.ValueDate;
addObj.PostDate = obj.PostDate;
addObj.MemberCase = obj.MemberCase;
addObj.Name = obj.Name;
addObj.Reference = obj.CardNumber;
addObj.Credit = obj.Credit;
addObj.Debit = obj.Debit;
addObj.IsActive = true;
db.NonCustom_GLReconciliationTable.Add(addObj);
db.SaveChanges();
}
}
public static Dictionary <string, string> GetDebitCreditAmountAfterReconciliation_CBHelper()
{
CaseStatisticsDataLayer CSD = new CaseStatisticsDataLayer();
return(CSD.GetDebitCreditAmountAfterReconciliation());
}