public LaderTypeCountReport(string FromDate, string FromTime, string ToDate, string ToTime, string LaderTypeList)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LaderTypeReportTable = new DataTable();
LadeAssignmentFactory.SelectLaderTypeCountReport(FromDate, FromTime, ToDate, ToTime, LaderTypeList, ref LaderTypeReportTable);
this.DataSource = LaderTypeReportTable;
FromDatetxt.Text = FromDate;
FromTimetxt.Text = FromTime;
ToDatetxt.Text = ToDate;
ToTimetxt.Text = ToTime;
UserNametxt.Text = HPS.Common.CurrentUser.user.UserName_nvc;
Datetxt.Text = LadeAssignmentFactory.ServerJalaliDate;
Timetxt.Text = LadeAssignmentFactory.ServerTime;
if (LaderTypeReportTable != null && LaderTypeReportTable.Rows.Count > 0)
{
LaderTypeReportTable.Columns.Add("RemainedPercent");
foreach (DataRow row in LaderTypeReportTable.Rows)
{
double RemainedPercent = (Convert.ToDouble(row["RemainderCar_int"]) * 100) / Convert.ToDouble(row["CarCount_int"]);
row["RemainedPercent"] = RemainedPercent.ToString("0.##");
}
LaderTypetxt.DataField = "LaderType_nvc";
LadeAssignmentCounttxt.DataField = "CarCount_int";
LadBillCounttxt.DataField = "LadBill";
RemainderCounttxt.DataField = "RemainderCar_int";
RemainedCountPercenttxt.DataField = "RemainedPercent";
canceledByCompanytxt.DataField = "CanceledByCompany";
canceledByLadBillCanceledtxt.DataField = "CanceledByLadBillCanceled";
//TrueLadBillCount_int.DataField = "CanceledLadeBill";
Int64?AllLadeAssignmentcount = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["CarCount_int"]).Sum();
AllLadeAssignmentCountxt.Text = AllLadeAssignmentcount.HasValue ? AllLadeAssignmentcount.ToString() : "0";
Int64?AllLadBillcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadBill"]).Sum();
AllLadBillCounttxt.Text = AllLadBillcountRecords.HasValue ? AllLadBillcountRecords.ToString() : "0";
//Int64? Allremaindercount = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["RemainderCar_int"]).Sum();
Int64?allcanceledByCompany = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["CanceledByCompany"]).Sum();
allCanceledByCompanytxt.Text = allcanceledByCompany.HasValue ? allcanceledByCompany.ToString() : "0";
Int64?allcanceledByLadBillCanceled = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["CanceledByLadBillCanceled"]).Sum();
allCanceledByLadBillCanceledtxt.Text = allcanceledByLadBillCanceled.HasValue ? allcanceledByLadBillCanceled.ToString() : "0";
AllRemainderCounttxt.Text = (Convert.ToInt64(AllLadeAssignmentcount) - Convert.ToInt64(AllLadBillcountRecords) - Convert.ToInt64(allcanceledByCompany) - Convert.ToInt64(allcanceledByLadBillCanceled)).ToString(); //Allremaindercount.HasValue ? Allremaindercount.ToString() : "0";
AllRemainedPercenttxt.Text = ((Convert.ToDouble(AllRemainderCounttxt.Text)) * 100 / (Convert.ToDouble(AllLadeAssignmentCountxt.Text))).ToString("0.##");
}
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}