protected void btnupdateRDInfo_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.RDID = string.IsNullOrEmpty(hfRDID.Value) ? 0 : Convert.ToInt32(hfRDID.Value);
p.RouteID = Convert.ToInt32(dpRoute.SelectedValue);
p.SupplierID = Convert.ToInt32(dpSupplier.SelectedValue);
p.RDStartDate = txtRDStartDate.Text;
p.RDMaturityDate = txtRDMaturityDate.Text;
p.RDAmount = string.IsNullOrEmpty(txtRDAmount.Text.ToString()) ? 0 : Convert.ToDouble(txtRDAmount.Text);
p.RepaymentAmt = string.IsNullOrEmpty(txtRDRepaymentAmount.Text.ToString()) ? 0 : Convert.ToDouble(txtRDRepaymentAmount.Text);
p.RDStatus = DropDownList1.SelectedItem.Text;
p.RDPaymentDateTime = txtRDPaymentDate.Text;
p.AccounNumber = txtAccountNo.Text;
p.BankName = dpBankName.SelectedItem.Text;
p.IFSCCode = dpIfscCode.SelectedItem.Text;
p.BranchName = txtBranchName.Text;
p.AccountName = txtAccountName.Text;
p.CreatedBy = App_code.GlobalInfo.Userid;
p.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
p.flag = "Update";
int Result = 0;
Result = pd.InsertSupplierRDInfo(p);
if (Result > 0)
{
//lbltital.Text = "Add Route";
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Supplier RD Info Updated Successfully";
ClearTextBox();
BindeSupplierRDInfo();
pnlError.Update();
btnAddRDInfo.Visible = true;
btnupdateRDInfo.Visible = false;
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnClick_btnLoanadd(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.LoanID = 0;
p.SupplierID = Convert.ToInt32(dpSupplier.SelectedValue);
p.LoanType = ddLoanType.SelectedItem.Text;
p.AccounNumber = txtLoanAccountNo.Text;
p.LoanAmount = Convert.ToDouble(txtLoanAmt.Text);
p.LoanTakenDate = txtLoanTakenDate.Text;
p.LoanDuration = txtLoanDuration.Text;
p.LoanPaid = Convert.ToDouble(txtLoadPaid.Text);
p.LoanStatus = DropDownList1.SelectedItem.Text;
p.BankName = dpBankName.SelectedItem.Text;
//p.BranchName = txtBranchName.Text;
p.IFSCCode = dpIfscCode.SelectedItem.Text;
p.Interest = Convert.ToDouble(txtInterest.Text);
p.LoanBalance = Convert.ToDouble(txtLoanBalance.Text);
p.CreatedBy = App_code.GlobalInfo.Userid;
p.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
p.flag = "Insert";
int Result = 0;
Result = pd.InsertSupplierLoanInfo(p);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Supplier Loan Info Add Successfully";
ClearTextBox();
BindeSupplierLoanInfo();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnClick_btnTariffUpdate(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.BankDetailsID = string.IsNullOrEmpty(hfBankID.Value) ? 0 : Convert.ToInt32(hfBankID.Value);
p.SupplierID = Convert.ToInt32(dpSupplier.SelectedValue);
p.AccounNumber = txtAccountNo.Text;
p.AccountType = DropDownList1.SelectedItem.Text;
p.BankName = dpBankName.SelectedItem.Text;
p.IFSCCode = dpIfscCode.SelectedItem.Text;
p.BankAddress = txtAddress.Text;
p.BranchName = txtBranchName.Text;
p.AccountType = DropDownList1.SelectedItem.Text;
p.CreatedBy = App_code.GlobalInfo.Userid;
p.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
p.flag = "Update";
int Result = 0;
Result = pd.InsertSupplierBankDetails(p);
if (Result > 0)
{
//lbltital.Text = "Add Route";
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "SupplierBank Details Updated Successfully";
ClearTextBox();
BindBankInfoList();
pnlError.Update();
btnTariffAdd.Visible = true;
btnTariffUpdate.Visible = false;
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnupdateAdvanceInfo_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.AdvanceID = string.IsNullOrEmpty(hfAdvanceID.Value) ? 0 : Convert.ToInt32(hfAdvanceID.Value);
p.VehicleID = Convert.ToInt32(dpVehical.SelectedValue);
p.AdvanceAmount = Convert.ToDouble(txtAdvanceAmount.Text);
p.AdvanceDateTime = txtAdvanceDate.Text;
p.AdvanceDeducted = Convert.ToDouble(txtAdvanceDeducted.Text);
p.AdvanceBalance = Convert.ToDouble(txtAdvanceBalance.Text);
p.DeductDateTime = txtDeductDate.Text;
p.Interest = Convert.ToDouble(txtInterest.Text);
p.Installments = Convert.ToInt32(txtInstallments.Text);
p.InstallmentAmount = Convert.ToDouble(txtInstallAmt.Text);
p.CreatedBy = App_code.GlobalInfo.Userid;
p.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
p.flag = "Update";
int Result = 0;
Result = pd.InsertSupplierAdvanceInfo(p);
if (Result > 0)
{
//lbltital.Text = "Add Route";
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Supplier Advance Info Updated Successfully";
ClearTextBox();
BindeSupplierAdvanceInfo();
pnlError.Update();
btnAddAdvanceInfo.Visible = true;
btnupdateAdvanceInfo.Visible = false;
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnAddTariff_Click(object sender, EventArgs e)
{
ProcurementData pd = new ProcurementData();
Model.Procurement p = new Model.Procurement();
int result = 0;
p.ID = 0;
p.QCat = txtQCat.Text.ToString();
p.QLow = string.IsNullOrEmpty(txtQLow.Text) ? 0 : Convert.ToDecimal(txtQLow.Text);
p.QHigh = string.IsNullOrEmpty(txtQHigh.Text) ? 0 : Convert.ToDecimal(txtQHigh.Text);
p.QIncentive = string.IsNullOrEmpty(txtQIncentive.Text) ? 0 : Convert.ToDecimal(txtQIncentive.Text);
p.Description = string.IsNullOrEmpty(txtDesc.Text) ? string.Empty : txtDesc.Text;
if (dpStatus.SelectedItem.Value == "1")
{
p.IsActive = true;
}
if (dpStatus.SelectedItem.Value == "0")
{
p.IsActive = false;
}
p.flag = "Insert";
result = pd.AllIncentiveTariff(p);
if (result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Incentive Tariff Added Successfully";
BindIncentiveList();
upMain.Update();
pnlError.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = " Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnupdateSchemeInfo_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.SchemeID = string.IsNullOrEmpty(hfScheme.Value) ? 0 : Convert.ToInt32(hfScheme.Value);
p.SupplierID = Convert.ToInt32(dpRoute.SelectedValue);
p.SchemeBonusYr = txtSchemeBonusYr.Text;
p.SchemeAmount = Convert.ToDouble(txtSchemeAmount.Text);
p.BonusAmount = Convert.ToDouble(txtBonusAmount.Text);
p.PaymentStatus = DropDownList1.SelectedItem.Text;
p.PaymentDateTime = txtPaymentDate.Text;
p.CreatedBy = App_code.GlobalInfo.Userid;
p.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
p.flag = "Update";
int Result = 0;
Result = pd.InsertSupplierSchemeInfo(p);
if (Result > 0)
{
//lbltital.Text = "Add Route";
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Supplier Scheme Bonus Info Updated Successfully";
ClearTextBox();
BindeSupplierSchemeInfo();
pnlError.Update();
btnAddBonus.Visible = true;
btnupdateBonus.Visible = false;
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
private void DeleteIncentiveTariffbyId(int incentivetariffid)
{
ProcurementData pd = new ProcurementData();
Model.Procurement p = new Model.Procurement();
int result = 0;
p.ID = string.IsNullOrEmpty(hftariff.Value) ? 0 : Convert.ToInt32(hftariff.Value);
p.QCat = txtQCat.Text.ToString();
p.QLow = string.IsNullOrEmpty(txtQLow.Text) ? 0 : Convert.ToDecimal(txtQLow.Text);
p.QHigh = string.IsNullOrEmpty(txtQHigh.Text) ? 0 : Convert.ToDecimal(txtQHigh.Text);
p.QIncentive = string.IsNullOrEmpty(txtQIncentive.Text) ? 0 : Convert.ToDecimal(txtQIncentive.Text);
if (dpStatus.SelectedItem.Value == "1")
{
p.IsActive = true;
}
if (dpStatus.SelectedItem.Value == "0")
{
p.IsActive = false;
}
p.flag = "Delete";
result = pd.AllIncentiveTariff(p);
if (result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Incentive Tariff Deleted Successfully";
BindIncentiveList();
upMain.Update();
pnlError.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = " Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
pd = new ProcurementData();
p = new Model.Procurement();
int Result = 0;
p.ID = string.IsNullOrEmpty(hfBrandId.Value) ? 0 : Convert.ToInt32(hfBrandId.Value);
p.particular = txtParticular.Text;
p.purpose = dpStatus.SelectedItem.Text;
if (dpIsActive.SelectedItem.Value == "1")
{
p.IsActive = true;
}
else if (dpIsActive.SelectedItem.Text == "2")
{
p.IsActive = false;
}
p.flag = "Update";
Result = pd.InsertReceiveandDisposeMaster(p);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Vehicle Type Updated Successfully";
GetReceiveDisposeHeadMaster();
upMain.Update();
pnlError.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = " Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
pd = new ProcurementData();
p = new Model.Procurement();
int Result = 0;
p.ID = 0;
p.particular = txtParticular.Text;
p.purpose = dpStatus.SelectedItem.Text;
if (dpIsActive.SelectedItem.Value == "1")
{
p.IsActive = true;
}
else if (dpIsActive.SelectedItem.Text == "2")
{
p.IsActive = false;
}
p.flag = "Insert";
Result = pd.InsertReceiveandDisposeMaster(p);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Receive & Dispose Head Master Added Successfully";
GetReceiveDisposeHeadMaster();
upMain.Update();
pnlError.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "This Record Already exists.";
pnlError.Update();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
ProcurementData pd = new ProcurementData();
DataSet DS = new DataSet();
Model.Procurement p = new Model.Procurement();
p.ToDate = Convert.ToDateTime(txtDate.Text);
p.flag1 = "Text";
DS = pd.ClosingStock(p);
if (DS.Tables[0].Rows.Count > 0)
{
p.ToDate = Convert.ToDateTime(txtDate.Text);
p.abjust = txtinput.Text;
int Result = 0;
Result = pd.UpdateStock(p);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Stock Record Add Successfully";
pnlError.Update();
upMain.Update();
//uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
else
{
lblerror.Visible = true;
}
}
protected void txtDate_TextChanged(object sender, EventArgs e)
{
ProcurementData pd = new ProcurementData();
DataSet DS = new DataSet();
Model.Procurement p = new Model.Procurement();
p.ToDate = Convert.ToDateTime(txtDate.Text);
p.flag1 = "Text";
DS = pd.ClosingStock(p);
if (DS.Tables[0].Rows.Count > 0)
{
btnUpdate.Enabled = true;
foreach (DataRow row in DS.Tables[0].Rows)
{
txtmorning.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Morningcollection"].ToString()) ? "0.00" : DS.Tables[0].Rows[0]["Morningcollection"].ToString();
txtevening.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["eveningcollection"].ToString()) ? "0.00" : DS.Tables[0].Rows[0]["eveningcollection"].ToString();
txtreceived.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Receivedcollection"].ToString()) ? "0.00" : DS.Tables[0].Rows[0]["Receivedcollection"].ToString();
txtdisposal.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["Disposalcollection"].ToString()) ? "0.00" : DS.Tables[0].Rows[0]["Disposalcollection"].ToString();;
txtclosing.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["closingstock"].ToString()) ? "0.00" : DS.Tables[0].Rows[0]["closingstock"].ToString();
txtopen.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["OpeningStock"].ToString()) ? "0.00" : DS.Tables[0].Rows[0]["OpeningStock"].ToString();
txttotalmilk.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["TotalMilkCollection"].ToString()) ? "0.00" : DS.Tables[0].Rows[0]["TotalMilkCollection"].ToString();
txtinput.Text = string.IsNullOrEmpty(DS.Tables[0].Rows[0]["adjustment"].ToString()) ? "0.00" : DS.Tables[0].Rows[0]["adjustment"].ToString();
}
}
else
{
txtmorning.Text = "0.00";
txtevening.Text = "0.00";
txtreceived.Text = "0.00";
txtdisposal.Text = "0.00";
txtclosing.Text = "0.00";
txtopen.Text = "0.00";
txttotalmilk.Text = "0.00";
txtinput.Text = "0.00";
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
DataSet DS = new DataSet();
//StringBuilder sb = new StringBuilder();
p.Date = Convert.ToDateTime(txtDate1.Text);
if (Convert.ToInt32(dpVehicleNo1.SelectedItem.Value) == 0)
{
p.VehicleNo = "0";
}
else
{
p.VehicleNo = dpVehicleNo1.SelectedItem.Text;
}
if (Convert.ToInt32(dpRoute1.SelectedItem.Value) == 0)
{
p.RouteID = 0;
}
else
{
p.RouteID = Convert.ToInt32(dpRoute1.SelectedItem.Value);
}
DS = pd.GetAllMilkCollectionTransportDetails(p);
//if (!Comman.Comman.IsDataSetEmpty(DS))
//{
rpMilkCollectionList.DataSource = DS;
rpMilkCollectionList.DataBind();
uprouteList.Update();
//}
}
catch (Exception) { }
}
protected void btnView_Click(object sender, EventArgs e)
{
//if (txtDate1.Text != "" && txtDate2.Text != "")
//{
ProcurementData pd = new ProcurementData();
DataSet DS1 = new DataSet();
Model.Procurement p = new Model.Procurement();
p.ToDate1 = Convert.ToDateTime(txtDate1.Text);
p.ToDate2 = Convert.ToDateTime(txtDate2.Text);
p.flag1 = "Date";
string result = string.Empty;
DS1 = pd.ClosingStock(p);
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
btnreport.Visible = true;
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border-collapse:collapse; border-spacing:0; border:none; } .dispnone {display:none;} .control-sidebar{display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("<col style = 'width:90px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='1'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='7' style='text-align:center'>");
sb.Append("<b>Nanjil Milk Collection Centre, Mulagumoodu, K.K.Dt.</b>");
sb.Append("</th colspan='7'>");
sb.Append("<th class='tg-yw4l' >");
sb.Append("TIN:330761667331<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<th class='tg-yw4l' rowspan='1'>");
sb.Append("</th>");
sb.Append("<td class='tg-yw4l' colspan='7' style='text-align:center'>");
sb.Append("<b><u>Opening/Closing Stock</u></b> <br/>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' >");
sb.Append("<b>PH:248370,248605</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='4' style='text-align:left'>");
sb.Append("<b>Date :</b> " + DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td colspan='4' style='text-align:right'>");
sb.Append("<b>From</b> " + Convert.ToDateTime(txtDate1.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append("<b> To</b> " + Convert.ToDateTime(txtDate2.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
//sb.Append("<b>Report Type:</b> Opening/Closing Stock ");
//+ " " + DS.Tables[1].Rows[0]["VehicleType"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
//sb.Append(Convert.ToDateTime(txtDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:center' colspan='1'><b>Date</b></td>");
sb.Append("<td style='text-align:center'><b>Opening Stock</b></td>");
sb.Append("<td style='text-align:center'><b>Morning Collection</b></td>");
sb.Append("<td style='text-align:center'><b>Evening Collection</b></td>");
sb.Append("<td style='text-align:center'><b>Received Collection</b></td>");
sb.Append("<td style='text-align:center'><b>Disposal Collection</b></td>");
sb.Append("<td style='text-align:center'><b>Closing Stock</b></td>");
sb.Append("<td style='text-align:center'><b>Total Milk Collection</b></td>");
sb.Append("<td style='text-align:center'><b>Adjustment</b></td>");
sb.Append("</tr>");
sb.Append("<tr>");
int count = 0;
double morning = 0.00;
double Totmornig = 0.00;
double evening = 0.00;
double Totevening = 0.00;
double received = 0.00;
double Totreceived = 0.00;
double disposal = 0.00;
double Totdisposal = 0.00;
double closing = 0.00;
double Totclosing = 0.00;
double opening = 0.00;
double Totopening = 0.00;
double milk = 0.00;
double Totmilk = 0.00;
double adjust = 0.00;
double Totadjust = 0.00;
foreach (DataRow row in DS1.Tables[0].Rows)
{
count++;
sb.Append("<td style = 'text-align:center' colspan='1'>");
sb.Append(Convert.ToDateTime(row["Date"]).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td style = 'text-align:center'>");
try { opening = Convert.ToDouble(row["OpeningStock"]); }
catch { opening = 0.00; }
Totopening += opening;
sb.Append(opening);
sb.Append("</td>");
sb.Append("<td style = 'text-align:center'>");
try { morning = Convert.ToDouble(row["Morningcollection"]); }
catch { morning = 0.00; }
Totmornig += morning;
sb.Append(morning);
sb.Append("</td>");
sb.Append("<td style = 'text-align:center'>");
try { evening = Convert.ToDouble(row["eveningcollection"]); }
catch { evening = 0.00; }
Totevening += evening;
sb.Append(evening);
sb.Append("</td>");
sb.Append("<td style = 'text-align:center'>");
try { received = Convert.ToDouble(row["Receivedcollection"]); }
catch { received = 0.00; }
Totreceived += received;
sb.Append(received);
sb.Append("</td>");
sb.Append("<td style = 'text-align:center'>");
try { disposal = Convert.ToDouble(row["Disposalcollection"]); }
catch { disposal = 0.00; }
Totdisposal += disposal;
sb.Append(disposal);
sb.Append("</td>");
sb.Append("<td style = 'text-align:center'>");
try { closing = Convert.ToDouble(row["closingstock"]); }
catch { closing = 0.00; }
Totclosing += closing;
sb.Append(closing);
sb.Append("</td>");
sb.Append("<td style = 'text-align:center'>");
try { milk = Convert.ToDouble(row["TotalMilkCollection"]); }
catch { milk = 0.00; }
Totmilk += milk;
sb.Append(milk);
sb.Append("<td style = 'text-align:center'>");
try { adjust = Convert.ToDouble(row["adjustment"]); }
catch { adjust = 0.00; }
Totadjust += adjust;
sb.Append(adjust);
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("<tr style='border-bottom:1px solid'><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:center;' colspan='1'>");
sb.Append("<b>Total :</b>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:center; '><b>" + Totopening + "</b></td>");
sb.Append("<td style='text-align:center; '><b>" + Totmornig + "</b></td>");
sb.Append("<td style='text-align:center; '><b>" + Totevening + "</b></td>");
sb.Append("<td style='text-align:center; '><b>" + Totreceived + "</b></td>");
sb.Append("<td style='text-align:center; '><b>" + Totdisposal + "</b></td>");
sb.Append("<td style='text-align:center; '><b>" + Totclosing + "</b></td>");
sb.Append("<td style='text-align:center; '><b>" + Totmilk + "</b></td>");
sb.Append("<td style='text-align:center; '><b>" + Totadjust + "</b></td>");
sb.Append("</tr>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
else
{
result = "No Records Found";
Payment.Text = result;
}
}
public void DeleteSupplierByID(int SupplierID)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.SupplierID = string.IsNullOrEmpty(hfprofileID.Value) ? 0 : Convert.ToInt32(hfprofileID.Value);
p.SupplierCode = string.Empty;
p.SupplierName = string.Empty;
p.CenterID = 0;
p.RouteID = 0;
p.SupplierAliasName = string.Empty;
p.JoiningDate = string.Empty;
p.IsActive = false;
p.Address1 = string.Empty;
p.Address2 = string.Empty;
p.Address3 = string.Empty;
p.EmailID = string.Empty;
p.MobileNo = string.Empty;
p.PhoneNo = string.Empty;
p.City = dpCity.SelectedItem.Text;
p.District = dpDistrict.SelectedItem.Text;
p.State = dpState.SelectedItem.Text;
p.Country = dpCountry.SelectedItem.Text;
//p.BankDetailsID = Convert.ToInt32(txtBankDetailID.Text);
//p.IncentiveTillDate = 0.0;
//p.ReccDeposit = 0.0;
//p.Bonus = 0.0;
//p.AdvaceGiven = 0.0;
//p.SchemeAmount = 0.0;
p.CreatedBy = App_code.GlobalInfo.Userid;
p.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
p.BankDetailsID = string.IsNullOrEmpty(HiddenField1.Value) ? 0 : Convert.ToInt32(HiddenField1.Value);
p.SupplierID = string.IsNullOrEmpty(hfprofileID.Value) ? 0 : Convert.ToInt32(hfprofileID.Value);
p.AccounNumber = string.Empty;
p.AccountType = DropDownList1.SelectedItem.Text;
//p.BankName = dpBankName.SelectedItem.Text;
p.IFSCCode = dpIfscCode.SelectedItem.Text;
p.BankAddress = string.Empty;
p.BranchName = string.Empty;
p.AccountType = DropDownList1.SelectedItem.Text;
p.AccountName = string.Empty;
p.flag = "Delete";
int Result = 0;
Result = pd.InsertSupplierPrfile(p);
if (Result > 0)
{
//lbltital.Text = "Add Route";
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Supplier Profile Deleted Successfully";
ClearTextBox();
BindSupplierList();
pnlError.Update();
btnSupplieradd.Visible = true;
btnSupplierUpdate.Visible = false;
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnGeneratereport_Click(object sender, EventArgs e)
{
int flag;
if (chkAllTS.Checked)
{
flag = 0;
}
else
{
flag = 1;
}
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.CenterID = Convert.ToInt32(dpCenter.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
double tsStart = 0;
double tsEnd = 0;
try
{
tsStart = Convert.ToDouble(txttsstart.Text);
tsEnd = Convert.ToDouble(txttsend.Text);
}
catch
{
tsStart = 0; tsEnd = 0;
}
DataSet DS = new DataSet();
// DS = pd.MonthlyRawMilkPurchaseSummary(Convert.ToInt32(dpCenter.SelectedItem.Value), Convert.ToDateTime(txtStartDate.Text).ToString("yyyy-MM-dd"), Convert.ToDateTime(txtEndDate.Text).ToString("yyyy-MM-dd"), tsStart, tsEnd, flag);
//Santosh or Karthik to solve above issue
DS = new DataSet();
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='6' style='text-align:center;font-size: 120%;'>");
if (Session["CollectionCenterLoggedIn"] != null)
{
sb.Append("<b>" + Session["CollectionCenterLoggedIn"].ToString() + "</b>");
}
else
{
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>");
}
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
//sb.Append("TIN:330761667331<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='6' style='text-align:center'>");
sb.Append("<b><u>Monthly Raw Milk Purchase Summary</u></b> <br/>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
//sb.Append("PH:248370,248605");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='2' style='text-align:left'>");
sb.Append("Date : " + DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(dpCenter.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("Start Date : " + Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append("End Date : " + Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Month</b>");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:center'>");
sb.Append("<b>Route</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>MilkInLtr.</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>FatInKg.</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>SNFKg.</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>TSKg.</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Amount</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
double amt = 0.00;
int count = 0;
decimal milkltr = 0;
decimal totalmilkltr = 0;
double fatinkg = 0.00;
double totalfatinkg = 0.00;
double snfinkg = 0.00;
double totalsnfinkg = 0.00;
double tsinkg = 0.00;
double totaltsinkg = 0.00;
double totalamt = 0.00;
foreach (DataRow row in DS.Tables[0].Rows)
{
count++;
sb.Append("<td style='text-align:left'>");
sb.Append(row["Months"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["RouteCode"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["RouteName"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { milkltr = Convert.ToDecimal(row["MilkInLtr"]); }
catch { milkltr = 0; }
totalmilkltr += milkltr;
sb.Append(Convert.ToDecimal(milkltr).ToString("0.0"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { fatinkg = Convert.ToDouble(row["FATInKG"]); }
catch { fatinkg = 0; }
totalfatinkg += fatinkg;
sb.Append(Convert.ToDecimal(fatinkg).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { snfinkg = Convert.ToDouble(row["SNFInKG"]); }
catch { snfinkg = 0; }
totalsnfinkg += snfinkg;
sb.Append(Convert.ToDecimal(snfinkg).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { tsinkg = Convert.ToDouble(row["TSInKg"]); }
catch { tsinkg = 0; }
totaltsinkg += tsinkg;
sb.Append(Convert.ToDecimal(tsinkg).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { amt = Convert.ToDouble(row["Amount"]); }
catch { amt = 0; }
totalamt += amt;
sb.Append(Convert.ToDecimal(amt).ToString("0.00"));
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='8'></td></tr>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append("<b>Total :</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalmilkltr).ToString("0.0") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalfatinkg).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalsnfinkg).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totaltsinkg).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalamt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'><td colspan='8'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append("<b>Average :</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(" ");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalmilkltr / count).ToString("0.0") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalfatinkg / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalsnfinkg / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totaltsinkg / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalamt / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
else
{
result = "No Records Found";
Payment.Text = result;
}
uprouteList.Update();
}
protected void btnClick_btnSupplieradd(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
//p.SupplierID = 0;
p.SupplierID = Convert.ToInt32(txtSupplierCode.Text);
p.SupplierCode = txtSupplierCode.Text;
p.SupplierName = txtSupplierName.Text;
p.CenterID = Convert.ToInt32(dpCenter.SelectedValue);
p.RouteID = Convert.ToInt32(dpRoute.SelectedValue);
p.SupplierAliasName = txtSupplierAliasName.Text;
p.JoiningDate = txtJoiningDate.Text;
if (DropDownList1.SelectedValue == "1")
{
p.IsActive = true;
}
if (DropDownList1.SelectedValue == "2")
{
p.IsActive = false;
}
p.Address1 = txtAddress1.Text;
p.Address2 = txtAddress2.Text;
p.Address3 = txtAddress3.Text;
p.EmailID = txtEmail.Text;
p.MobileNo = txtMobile.Text;
p.PhoneNo = txtTelephone.Text;
p.City = dpCity.SelectedItem.Text;
p.District = dpDistrict.SelectedItem.Text;
p.State = dpState.SelectedItem.Text;
p.Country = dpCountry.SelectedItem.Text;
//p.BankDetailsID = Convert.ToInt32( txtBankDetailID.Text);
//p.IncentiveTillDate =Convert.ToDouble( txtIncentive.Text);
//p.ReccDeposit = Convert.ToDouble(txtDeposit.Text);
//p.Bonus = Convert.ToDouble(txtBonus.Text);
//p.AdvaceGiven = Convert.ToDouble(txtAdvanceGiven.Text);
//p.SchemeAmount = Convert.ToDouble(txtScheme.Text);
p.CreatedBy = App_code.GlobalInfo.Userid;
p.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
//p.BankDetailsID = 0;
//p.SupplierID = 0;
p.AccounNumber = txtAccountNo.Text;
p.AccountType = string.Empty;
p.BankName = string.Empty;
p.IFSCCode = string.Empty;
p.BankAddress = string.Empty;
p.BranchName = string.Empty;
p.BankDetailsID = Convert.ToInt32(dpIfscCode.SelectedItem.Value);
p.AccountName = txtAccountName.Text;
p.flag = "Insert";
int Result = 0;
Result = pd.InsertSupplierPrfile(p);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Supplier Profile Add Successfully";
ClearTextBox();
BindSupplierList();
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
protected void btnGeneratereport_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
DataSet DS1 = new DataSet();
DS1 = pd.SupplierWiseMilkqtyandQlty(p);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='6' style='text-align:center;font-size: 120%';>");
if (Session["CollectionCenterLoggedIn"] != null)
{
sb.Append("<b>" + Session["CollectionCenterLoggedIn"].ToString() + "</b>");
}
else
{
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>");
//sb.Append("<b>" + (string.IsNullOrEmpty(DS1.Tables[1].Rows[0]["CenterName"].ToString()) ? string.Empty : DS1.Tables[1].Rows[0]["CenterName"].ToString()) + "</b>");
}
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-baqh' colspan='6' style='text-align:center'>");
sb.Append("<b><u>Supplierwise Raw Milk Quantity & Quality Report</u> </b><br/>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='2' style='text-align:left'>");
string Route = "";
if (dpRoute.SelectedIndex == 0)
{
Route = "All Route";
sb.Append(Route);
}
else
{
Route = (dpRoute.SelectedItem.Text.ToString());
sb.Append(Route);
}
sb.Append("</td>");
sb.Append("<td colspan='3'>");
sb.Append(DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append("From : " + Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append("To : " + Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:center'>");
sb.Append("<b>Supplier</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>MilkInLtr</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>FAT %</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>SNF %</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>TS %</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Rate</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Incentive</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Amount</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
int count = 0;
decimal milkinLtr = 0;
decimal totalmilkinLtr = 0;
double fatpercentage = 0.00;
double totalfatpercentage = 0.00;
double snfpercentage = 0.00;
double totalsnfpercentage = 0.00;
double tspercentage = 0.00;
double totaltspercentage = 0.00;
double rate = 0.00;
double totalrate = 0.00;
double amt = 0.00;
double totalamt = 0.00;
double fatkg = 0.00;
double totfatkg = 0.00;
double snfkg = 0.00;
double totsnfkg = 0.00;
double tskg = 0.00;
double tottskg = 0.00;
double milkinkg = 0.00;
double totmilkinkg = 0.00;
double Incentive = 0.00;
double totalIncentive = 0.00;
double totfat = 0.00;
double totsnf = 0.00;
double totts = 0.00;
foreach (DataRow row in DS1.Tables[0].Rows)
{
count++;
sb.Append("<td>");
sb.Append(row["SupplierCode"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["SupplierName"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { milkinLtr = Convert.ToDecimal(row["MilkInLtr"]); } catch { milkinLtr = 0; }
totalmilkinLtr += milkinLtr;
sb.Append(Convert.ToDecimal(milkinLtr).ToString("0.0"));
try { milkinkg = Convert.ToDouble(row["MilkInKG"]); } catch { milkinkg = 0; }
totmilkinkg += milkinkg;
sb.Append("</td>");
//sb.Append("<td style='text-align:right'>");
//try { milkinkg = Convert.ToDouble(row["MilkInKG"]); } catch { milkinkg = 0; }
//totmilkinkg += milkinkg;
//sb.Append(Convert.ToDecimal(milkinkg).ToString("0.0"));
//sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { fatpercentage = Convert.ToDouble(row["FATPercentage"]); } catch { fatpercentage = 0.00; }
totalfatpercentage += fatpercentage;
sb.Append(Convert.ToDecimal(fatpercentage).ToString("0.00"));
try { fatkg = Convert.ToDouble(row["FATInKG"]); } catch { fatkg = 0; }
totfatkg += fatkg;
sb.Append("</td>");
//try { fatkg = Convert.ToDouble(row["FATInKG"]); } catch { fatkg = 0; }
//totfatkg += fatkg;
//sb.Append(Convert.ToDecimal(fatpercentage).ToString("0.00"));
//sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { snfpercentage = Convert.ToDouble(row["SNFPercentage"]); } catch { snfpercentage = 0.00; }
totalsnfpercentage += snfpercentage;
try { snfkg = Convert.ToDouble(row["SNFInKG"]); } catch { snfkg = 0; }
totsnfkg += snfkg;
sb.Append(Convert.ToDecimal(snfpercentage).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { tspercentage = Convert.ToDouble(row["TSPercentage"]); } catch { tspercentage = 0.00; }
totaltspercentage += tspercentage;
try { tskg = Convert.ToDouble(row["TSInKG"]); } catch { tskg = 0; }
tottskg += tskg;
sb.Append(Convert.ToDecimal(tspercentage).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { rate = Convert.ToDouble(row["Rate"]); } catch { rate = 0.00; }
totalrate += rate;
sb.Append(Convert.ToDecimal(rate).ToString("0.00"));
sb.Append("</td>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { Incentive = Convert.ToDouble(row["Incentive"]); } catch { rate = 0.00; }
totalIncentive += Incentive;
sb.Append(Convert.ToDecimal(Incentive).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { amt = Convert.ToDouble(row["Amount"]); } catch { amt = 0.00; }
totalamt += amt;
sb.Append(Convert.ToDecimal(amt).ToString("0.00"));
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='9'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='3'>");
sb.Append("<b>Average</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalfatpercentage / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalsnfpercentage / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totaltspercentage / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalrate / count).ToString("0.00") + "/ Lt." + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalIncentive / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td >");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("<b>Total</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + totalmilkinLtr + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
totfat = Convert.ToDouble((totalfatpercentage) / count) * (totmilkinkg / 100);
sb.Append("<b>" + Convert.ToDecimal(totfat).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
totsnf = Convert.ToDouble((totalsnfpercentage) / count) * (totmilkinkg / 100);
sb.Append("<b>" + Convert.ToDecimal(totsnf).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
totts = Convert.ToDouble((totaltspercentage) / count) * (totmilkinkg / 100);
sb.Append("<b>" + Convert.ToDecimal(totts).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
//sb.Append("<b>" + Convert.ToDecimal(totalrate).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalIncentive).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalamt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
else
{
result = "No Records Found";
Payment.Text = result;
}
uprouteList.Update();
}
protected void btnGeneratereport_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.CenterID = Convert.ToInt32(dpCenter.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
// p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
DataSet DS = new DataSet();
DS = pd.ConsolidatePayementSummary(p);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS))
{
try
{
DS.Tables[0].PrimaryKey = new[] { DS.Tables[0].Columns["RouteID"] };
}
catch (Exception) { }
try
{
DS.Tables[2].PrimaryKey = new[] { DS.Tables[2].Columns["RouteID"] };
}
catch (Exception) { }
try
{
DS.Tables[3].PrimaryKey = new[] { DS.Tables[3].Columns["RouteID"] };
}
catch (Exception) { }
try
{
DS.Tables[4].PrimaryKey = new[] { DS.Tables[4].Columns["RouteID"] };
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[2], false, MissingSchemaAction.Add);
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[3], false, MissingSchemaAction.Add);
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[4], false, MissingSchemaAction.Add);
}
catch (Exception) { }
try
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='7' style='text-align:center'>");
sb.Append("<u>Consolidate Payment Summary</u> <br/>");
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("TIN:330761667331<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='7' style='text-align:center'>");
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("PH:248370,248605");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='2' style='text-align:left'>");
sb.Append("Date : " + DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(dpCenter.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2' >");
sb.Append("");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append("From : " + Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("To: " + Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:center'>");
sb.Append("<b>Route</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>MilkInLtr</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Amount</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Scheme</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>RD</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Can Loan</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Cash Loan</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Net Amount</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
double milkinlter = 0.00;
double scheme = 0.00;
double supplierscheme = 0.00;
double rd = 0.00;
double canloan = 0.00;
double casloan = 0.00;
double netamt = 0.00;
double amt = 0.00;
int count = 0;
double totalmilkinlter = 0.00;
double totalsupplierscheme = 0.00;
double totalrd = 0.00;
double totalcanloan = 0.00;
double totalcasloan = 0.00;
double totalnetamt = 0.00;
double totalamt = 0.00;
foreach (DataRow row in DS.Tables[0].Rows)
{
foreach (DataRow rows in DS.Tables[1].Rows)
{
if (row["Category"].ToString() == rows["Category"].ToString())
{
count++;
sb.Append("<td>");
sb.Append(row["RouteCode"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["RouteName"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try
{
milkinlter = Convert.ToDouble(row["MilkInLtr"]);
}
catch { milkinlter = 0.00; }
sb.Append(Convert.ToDecimal(milkinlter).ToString("0.0"));
totalmilkinlter += milkinlter;
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try
{
amt = Convert.ToDouble(row["Amount"]);
}
catch { amt = 0.00; }
sb.Append(Convert.ToDecimal(amt).ToString("0.00"));
totalamt += amt;
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try
{
scheme = Convert.ToDouble(rows["Scheme"]);
}
catch { scheme = 0.00; }
supplierscheme = scheme * milkinlter;
sb.Append(Convert.ToDecimal(supplierscheme).ToString("0.00"));
totalsupplierscheme += supplierscheme;
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try
{
rd = Convert.ToDouble(row["RDAmt"]);
}
catch { rd = 0.00; }
sb.Append(Convert.ToDecimal(rd).ToString("0.00"));
totalrd += rd;
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try
{
canloan = Convert.ToDouble(row["CanLoanPaid"]);
}
catch { canloan = 0.00; }
sb.Append(Convert.ToDecimal(canloan).ToString("0.00"));
totalcanloan += canloan;
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try
{
casloan = Convert.ToDouble(row["CashLoanPaid"]);
}
catch { casloan = 0.00; }
sb.Append(Convert.ToDecimal(casloan).ToString("0.00"));
totalcasloan += casloan;
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
netamt = (amt - (supplierscheme + rd + canloan + casloan));
sb.Append(Convert.ToDecimal(netamt).ToString("0.00"));
totalnetamt += netamt;
sb.Append("</td>");
sb.Append("</tr>");
}
}
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='9'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Total :</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalmilkinlter).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalamt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalsupplierscheme).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalrd).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalcanloan).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalcasloan).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalnetamt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
catch
{
result = "No Records Found";
Payment.Text = result;
}
}
else
{
result = "No Records Found";
Payment.Text = result;
}
uprouteList.Update();
}
protected void btnExportinText_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.flag = "Notepad";
p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
if (dpBankName.SelectedItem.Value == "0")
{
p.BankName = "0";
}
else
{
p.BankName = dpBankName.SelectedItem.Text;
}
if (dpIfscCode.SelectedItem.Value == "0")
{
p.IFSCCode = "0";
}
else
{
p.IFSCCode = dpIfscCode.SelectedItem.Text;
}
DataSet DS1 = new DataSet();
DS1 = pd.RawMilkPaymentListViaBank(p);
//SqlCommand cmd = new SqlCommand(strQuery);
//DataTable dt = GetData(cmd);
//Create a dummy GridView
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
DataSet DS2 = new DataSet();
DS2 = pd.RawMilkPaymentListViaBankExcel(p);
GridView GridView1 = new GridView();
GridView1.ShowHeader = false;
GridView1.AllowPaging = false;
GridView1.DataSource = DS2;
GridView1.DataBind();
string txt = string.Empty;
foreach (TableCell cell in GridView1.HeaderRow.Cells)
{
//Add the Header row for Text file.
// txt += cell.Text + "\t\t";
}
//txt += "\r\n";
Response.Clear();
Response.Buffer = true;
string filename = DS2.Tables[1].Rows[0]["CenterCode"] + "" + "_" + dpIfscCode.SelectedItem.Text + "" + "_" + DateTime.Now.ToString("dd-MM-yyyy").ToString();
Response.AddHeader("content-disposition", "attachment;filename= " + filename + ".txt");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.text";
foreach (GridViewRow row in GridView1.Rows)
{
foreach (TableCell cell in row.Cells)
{
//Add the Data rows.
txt += cell.Text;
}
//Add new line.
txt += "\r\n";
}
Response.Output.Write(txt.ToString());
Response.End();
}
else
{
result = "No Records to download";
Payment.Text = result;
}
}
protected void btnExporttoexcell_Click1(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.flag = "Excel";
p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
if (dpBankName.SelectedItem.Value == "0")
{
p.BankName = "0";
}
else
{
p.BankName = dpBankName.SelectedItem.Text;
}
if (dpIfscCode.SelectedItem.Value == "0")
{
p.IFSCCode = "0";
}
else
{
p.IFSCCode = dpIfscCode.SelectedItem.Text;
}
DataSet DS1 = new DataSet();
DS1 = pd.RawMilkPaymentListViaBank(p);
//Create a dummy GridView
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
DataSet DS2 = new DataSet();
DS2 = pd.RawMilkPaymentListViaBankExcel(p);
GridView GridView1 = new GridView();
GridView1.ShowHeader = false;
GridView1.AllowPaging = false;
GridView1.DataSource = DS2;
GridView1.DataBind();
Response.Clear();
Response.Buffer = true;
string filename = DS2.Tables[1].Rows[0]["CenterCode"] + "" + "_" + dpIfscCode.SelectedItem.Text + "" + "_" + DateTime.Now.ToString("dd-MM-yyyy").ToString();
//string filename = DS2.Tables[1].Rows[0]["CenterCode"]+"" + "_" + DS2.Tables[0].Rows[0]["IFSCCode"] + "" + "_" + DateTime.Now.ToString("dd-MM-yyyy").ToString();
Response.AddHeader("content-disposition", "attachment;filename= " + filename + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
for (int i = 0; i < GridView1.Rows.Count; i++)
{
//Apply text style to each Row
GridView1.Rows[i].Attributes.Add("class", "textmode");
}
GridView1.RenderControl(hw);
//style to format numbers to string
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
else
{
result = "No Records to download";
Payment.Text = result;
}
}
protected void btnGeneratereport_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
if (dpBankName.SelectedItem.Value == "0")
{
p.BankName = "0";
}
else
{
p.BankName = dpBankName.SelectedItem.Text;
}
if (dpIfscCode.SelectedItem.Value == "0")
{
p.IFSCCode = "0";
}
else
{
p.IFSCCode = dpIfscCode.SelectedItem.Text;
}
DataSet DS1 = new DataSet();
DS1 = pd.RawMilkPaymentListViaBank(p);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
//ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "showDiv()", true);
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='11' style='text-align:center'>");
sb.Append("<u>Raw Milk Payment List Via Bank</u> <br/>");
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='11' style='text-align:center'>");
if (Session["CollectionCenterLoggedIn"] != null)
{
sb.Append("<b>" + Session["CollectionCenterLoggedIn"].ToString() + "</b>");
}
else
{
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>");
}
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("PH:248370,248605");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='3' style='text-align:left'>");
sb.Append("Date : " + DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(dpRoute.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(dpBankName.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(dpIfscCode.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("Date : " + Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy "));
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(" To : " + Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:center'>");
sb.Append("<b>Supplier</b>");
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("<b>Bank A/C No.</b>");
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("<b>Loan A/C No.</b>");
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("<b>A/C Name</b>");
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("<b>Payment Amt</b>");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:center'>");
sb.Append("<b>Amount</b>");
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("<b>Net Amount</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
int count = 0;
double netamt = 0;
double loanamt = 0;
double loanpaid = 0;
double totalnetamt = 0;
double totalloanamt = 0;
double totalloanpaid = 0;
foreach (DataRow row in DS1.Tables[0].Rows)
{
count++;
sb.Append("<td>");
sb.Append(row["SupplierCode"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["SupplierName"].ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(row["AccountNo"].ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(row["LoanAccountNo"].ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(row["AccountName"].ToString());
sb.Append("</td>");
sb.Append("<td colspan='2'>");
try { loanamt = Convert.ToDouble(row["LoanAmount"]); }
catch { loanamt = 0.00; }
totalloanamt += loanamt;
sb.Append(loanamt);
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:center'>");
try { loanpaid = Convert.ToDouble(row["LoanAmtPaid"]); }
catch { loanpaid = 0.00; }
totalloanpaid += loanpaid;
sb.Append(loanpaid);
sb.Append("</td>");
sb.Append("<td colspan='2'>");
netamt = loanamt - loanpaid;
totalnetamt += netamt;
sb.Append(netamt);
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='13'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Total</b>");
sb.Append("</td>");
sb.Append("<td colspan='7' style='text-align:left'>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("<b>" + totalloanamt + "</b>");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:center'>");
sb.Append("<b>" + totalloanpaid + "</b>");
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("<b>" + totalnetamt + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
else
{
result = "No Records Found";
Payment.Text = result;
}
uprouteList.Update();
}
protected void btnGeneratereport_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
p.VehicleNo = dpVehicleNo.SelectedItem.Text;
DataSet DS = new DataSet();
DS = pd.MilkCollectionTransportBill(p);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='5' style='text-align:center'>");
if (Session["CollectionCenterLoggedIn"] != null)
{
sb.Append("<b>" + Session["CollectionCenterLoggedIn"].ToString() + "</b>");
}
else
{
sb.Append("<b>Nanjil Milk Collection Centre,Naguneri</b>");
}
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("TIN:330761667331<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='5' style='text-align:center'>");
sb.Append("<u>Milk Collection Transporting Bill</u> <br/>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("PH:248370,248605");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='2' style='text-align:left'>");
sb.Append("Date : " + DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td colspan='3'>");
sb.Append(dpVehicleNo.SelectedItem.Text.ToString() + " " + DS.Tables[1].Rows[0]["VehicleType"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Date</b>");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:center'>");
sb.Append("<b>Route</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>KM.</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Amount</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Bata</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Total Amount</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
double amt = 0.00;
int count = 0;
double km = 0.00;
double totalkm = 0.00;
double bata = 0.00;
double totalbata = 0.00;
double totalamt = 0.00;
double totalnetamt = 0.00;
double netamt = 0.00;
foreach (DataRow row in DS.Tables[0].Rows)
{
count++;
sb.Append("<td style='text-align:left'>");
sb.Append(Convert.ToDateTime(row["Date"]).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td>");
//sb.Append(row["RouteCode"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["RouteName"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { km = Convert.ToDouble(row["TotalKM"]); }
catch { km = 0.00; }
totalkm += km;
sb.Append(Convert.ToDecimal(km).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { amt = Convert.ToDouble(row["Amount"]); }
catch { amt = 0.0; }
totalamt += amt;
sb.Append(Convert.ToDecimal(amt).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { bata = Convert.ToDouble(row["Bata"]); }
catch { bata = 0; }
totalbata += bata;
sb.Append(Convert.ToDecimal(bata).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
netamt = amt + bata;
totalnetamt += netamt;
sb.Append(Convert.ToDecimal(netamt).ToString("0.00"));
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='8'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append("<b>Total :</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalkm).ToString("0.0") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalamt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalbata).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalnetamt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='3' style='text-align:left'> <b>Driver Name: " + DS.Tables[1].Rows[0]["VehicleOwnerName"].ToString() + "</b></td>");
sb.Append("<td colspan='3' style='text-align:left'> <b>A/c.No: " + DS.Tables[1].Rows[0]["AccountNo"].ToString() + "</b></td>");
sb.Append("<td colspan='3' style='text-align:right'><b> IFSC: " + DS.Tables[1].Rows[0]["IFSCCode"].ToString() + "</b> </td>");
sb.Append("</tr>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
else
{
result = "No Records Found";
Payment.Text = result;
}
uprouteList.Update();
}
protected void btnGeneratereport_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
p.SupplierID = Convert.ToInt32(dpSupplier.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
DataSet DS1 = new DataSet();
DS1 = pd.RawMilkPurchaseBillSummary(p);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:125px'>");
sb.Append("<col style = 'width:125px'>");
sb.Append("<col style = 'width:125px'>");
sb.Append("<col style = 'width:125px'>");
sb.Append("<col style = 'width:125px'>");
sb.Append("<col style = 'width:125px'>");
sb.Append("<col style = 'width:125px'>");
sb.Append("<col style = 'width:125px'>");
//sb.Append("<col style = 'width:125px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='7' style='text-align:center;font-size: 120%';>");
if (Session["CollectionCenterLoggedIn"] != null)
{
sb.Append(Session["CollectionCenterLoggedIn"]);
}
else
{
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>");
}
sb.Append("</th>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-baqh' colspan='5' style='text-align:center'>");
sb.Append("<b><u>Raw Milk Purchase Bill Report</u> </b><br/>");
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append("<b>Date :</b>");
sb.Append(DateTime.Now.ToString());
sb.Append("</td>");
//sb.Append("<td class='tg-yw4l' style='text-align:right'>");
//sb.Append("");
//sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='2' style='text-align:left'>");
sb.Append(dpRoute.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append(" <td colspan='3' style='text-align:center'>");
sb.Append(dpSupplier.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:right'>");
sb.Append("From : " + Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td colspan='1' style='text-align:right'>");
sb.Append("To : " + Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
int count = 0;
decimal milkinLtr = 0;
decimal totalmilkinLtr = 0;
double fatpercentage = 0.00;
double totalfatpercentage = 0.00;
double snfpercentage = 0.00;
double totalsnfpercentage = 0.00;
double tspercentage = 0.00;
double totaltspercentage = 0.00;
double rate = 0.00;
double totalrate = 0.00;
double amt = 0.00;
double totalamt = 0.00;
double scheme = 0.00;
int can = 0;
double RDAmt = 0.00;
double LoanAmt = 0.00;
double NetAmt = 0.00;
double LoanBL = 0.00;
double totalLoanBL = 0.00;
double totcount = 0;
decimal totmilkinLtr = 0;
double totfatpercentage = 0.00;
double totsnfpercentage = 0.00;
double tottspercentage = 0.00;
double totrate = 0.00;
double totLoanBL = 0.00;
double totamt = 0.00;
foreach (DataRow rows in DS1.Tables[1].Rows)
{
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='8' style='text-align:left'>");
sb.Append((rows["SupplierName"]).ToString());
sb.Append("</td>");
sb.Append("</tr>");
count = 0;
totalmilkinLtr = 0;
totalfatpercentage = 0.00;
totalsnfpercentage = 0.00;
totaltspercentage = 0.00;
totalrate = 0.00;
totalLoanBL = 0.00;
totalamt = 0.00;
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='1' style='text-align:center'>");
sb.Append("<b>Date</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Session</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>MilkInLtr</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>FAT %</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>SNF %</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>TS %</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Rate</b>");
sb.Append("</td>");
//sb.Append("<td style='text-align:right'>");
//sb.Append("<b>Loan Amt</b>");
//sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Amount</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
foreach (DataRow row in DS1.Tables[0].Rows)
{
if (row["SupplierID"].ToString() == rows["SupplierID"].ToString())
{
//if (row["_Date"].ToString() == rows["_Date"].ToString())
//{
count++;
//sb.Append("<td>");
////sb.Append(row["SupplierCode"].ToString());
//sb.Append("</td>");
sb.Append("<td style='text-align:center'>");
sb.Append(Convert.ToDateTime(row["_Date"]).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append((row["_Session"]).ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { milkinLtr = Convert.ToDecimal(row["MilkInLtr"]); } catch { milkinLtr = 0; }
totalmilkinLtr += milkinLtr;
sb.Append(Convert.ToDecimal(milkinLtr).ToString("0.0"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { fatpercentage = Convert.ToDouble(row["FATPercentage"]); } catch { fatpercentage = 0.00; }
totalfatpercentage += fatpercentage;
sb.Append(Convert.ToDecimal(fatpercentage).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { snfpercentage = Convert.ToDouble(row["SNFPercentage"]); } catch { snfpercentage = 0.00; }
totalsnfpercentage += snfpercentage;
sb.Append(Convert.ToDecimal(snfpercentage).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { tspercentage = Convert.ToDouble(row["TSPercentage"]); } catch { tspercentage = 0.00; }
totaltspercentage += tspercentage;
sb.Append(Convert.ToDecimal(tspercentage).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { rate = Convert.ToDouble(row["Rate"]); } catch { rate = 0.00; }
totalrate += rate;
sb.Append(Convert.ToDecimal(rate).ToString("0.00"));
sb.Append("</td>");
//sb.Append("<td style='text-align:right'>");
//try { LoanBL = Convert.ToDouble(row["LoanBalance"]); } catch { rate = 0.00; }
//totalLoanBL += LoanBL;
//sb.Append(Convert.ToDecimal(LoanBL).ToString("0.00"));
//sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
try { amt = Convert.ToDouble(row["Amount"]); } catch { amt = 0.00; }
totalamt += amt;
sb.Append(Convert.ToDecimal(amt).ToString("0.00"));
sb.Append("</td>");
try { scheme = Convert.ToDouble(row["Scheme"]); } catch { amt = 0.00; }
try { can = Convert.ToInt32(row["Can"]); } catch { amt = 0.00; }
try { RDAmt = Convert.ToDouble(row["RDAmount"]); } catch { RDAmt = 0.00; }
try { LoanAmt = Convert.ToDouble(row["LoanAmount"]); } catch { LoanAmt = 0.00; }
try { LoanBL = Convert.ToDouble(row["LoanBalance"]); } catch { LoanBL = 0.00; }
sb.Append("</tr>");
//}
}
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='9'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='3'>");
sb.Append("<b>Average</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalfatpercentage / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalsnfpercentage / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totaltspercentage / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalrate / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("/ Lt.");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("<b>Total</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + totalmilkinLtr + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalfatpercentage).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalsnfpercentage).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totaltspercentage).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalrate).ToString("0.00") + "</b>");
sb.Append("</td>");
//sb.Append("<td style='text-align:right'>");
//sb.Append("<b>" + Convert.ToDecimal(totalLoanBL).ToString("0.00") + "</b>");
//sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalamt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</tr>");
sb.Append("<td style='text-align:center' colspan = '1'>");
sb.Append("<b>Less Scheme: </b>");
sb.Append("<b>" + Convert.ToDecimal(scheme).ToString("0.00") + "</b>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Less RD: </b>");
sb.Append("<b>" + Convert.ToDecimal(RDAmt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Can: </b>");
sb.Append("<b>" + Convert.ToDecimal(can).ToString() + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:center' colspan='2'>");
sb.Append("<b>Less Loan: </b>");
sb.Append("<b>" + Convert.ToDecimal(LoanAmt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:center' colspan='2'>");
sb.Append("<b>BL LoanAmt : </b>");
sb.Append("<b>" + Convert.ToDecimal(LoanBL).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style = 'text-align:right' colspan='1'>");
sb.Append("<b> NetAmt: </b>");
NetAmt = totalamt - LoanAmt - can - RDAmt - scheme;
NetAmt = (NetAmt < 0 ? -NetAmt : NetAmt);
sb.Append("<b>" + Convert.ToDecimal(NetAmt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'><td colspan='9'></td></tr>");
totcount += count;
totmilkinLtr += totalmilkinLtr;
totfatpercentage += totalfatpercentage;
totsnfpercentage += totalsnfpercentage;
tottspercentage += totaltspercentage;
totrate += totalrate;
totLoanBL += totalLoanBL;
totamt += totalamt;
}
sb.Append("<tr>");
sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '10'> </td> </tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("<b>Count</b>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("<b>" + totcount + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + totmilkinLtr + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totfatpercentage).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totsnfpercentage).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(tottspercentage).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totrate).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totLoanBL).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totamt).ToString("0.00") + "</b>");
sb.Append("</td>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
else
{
result = "No Records Found";
Payment.Text = result;
}
uprouteList.Update();
}
protected void btnCalculate_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.CollectionID = 6;//Convert.ToInt32(dpCenter.SelectedItem.Value);
p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtFromDate.Text);
p.ToDate = Convert.ToDateTime(txtToDate.Text);
p.flag = "1";
if (dpSession.SelectedItem.Value == "0")
{
p.Session = null;
}
else
{
p.Session = dpSession.SelectedItem.Text.ToString();
}
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString();
DataSet DS1 = new DataSet();
DS1 = pd.CalculateBill(p);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS1))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border-collapse:collapse; border-spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' ;");
sb.Append("style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<td class='tg-yw4l' colspan='7' style='text-align:center'>");
if (Session["CollectionCenterLoggedIn"] != null)
{
sb.Append("<b>" + Session["CollectionCenterLoggedIn"].ToString() + "</b>");
}
else
{
sb.Append("<b>Nanjil Integrated Dairy Development, Mulagumoodu, K.K.Dt.</b>");
}
sb.Append("</td>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("TIN:330761667331<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<th class='tg-baqh' colspan='7' style='text-align:center'>");
sb.Append("<u>Check List </u> <br/>");
sb.Append("</th>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("<b>PH:248370,248605</b>");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td style='text-align:left'>");
if (dpSession.SelectedItem.Value == "0")
{
sb.Append("Shift : All");
}
else
{
sb.Append("Shift :" + dpSession.SelectedItem.Text);
}
sb.Append("</td>");
sb.Append(" <td colspan='2' style='text-align:center'>");
sb.Append(DateTime.Now.ToString("dd'-'MM'-'yyyy HH:mm:ss"));
sb.Append("</td>");
sb.Append("<td colspan='2' style='text-align:center'>");
sb.Append(App_code.GlobalInfo.UserName);
sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append(dpRoute.SelectedItem.Text.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtFromDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtToDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
int count = 0;
int can = 0;
int totalcan = 0;
double milkinkg = 0.00;
double totalmilkkg = 0.00;
double milkinltr = 0.00;
double totalmilklter = 0.00;
double clr = 0.00;
double totalclr = 0.00;
double fatpercent = 0.00;
double totalfatpercent = 0.00;
double snfpercent = 0.00;
double totalsnfpercent = 0.00;
double tspercent = 0.00;
double fatinkg = 0.00;
double totalfatinkg = 0.00;
double ttlfatinkg = 0.00;
double snfinkg = 0.00;
double totalsnfinkg = 0.00;
double ttlsnfinkg = 0.00;
double tsinkg = 0.00;
double totaltsinkg = 0.00;
double ttltsinkg = 0.00;
double totaltspercent = 0.00;
double totfat = 0.00;
double totsnf = 0.00;
double totmillkg = 0.00;
double totmilkltr = 0.00;
int totcan = 0;
double totts = 0.00;
double totclr = 0.00;
string Date;
int countavg = 0;
int totcount = 0;
foreach (DataRow rows in DS1.Tables[1].Rows)
{
count = 0;
totalfatpercent = 0.00;
totalsnfpercent = 0.00;
totalmilkkg = 0.00;
totalmilklter = 0.00;
totalcan = 0;
totaltspercent = 0.00;
totalclr = 0.00;
sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '9'> </td> </tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='3' style='font-weight:bold'>");
Date = Convert.ToDateTime(rows["_Date"]).ToString("dd-MM-yyyy");
sb.Append("<b>Date : </b>" + Date.ToString());
sb.Append("</td>");
sb.Append("<td colspan='3' style='font-weight:bold; text-align:Center' >");///////////
sb.Append("<b>Route : </b>" + rows["RouteName"].ToString());
sb.Append("</td>");
sb.Append("<td colspan='3' style='font-weight:bold; text-align:right' >");
sb.Append("<b>Time : </b>" + rows["_Session"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
//sb.Append("<td>");
//sb.Append("<b>Date</b>");
//sb.Append("</td>");
sb.Append("<td colspan='2'>");
sb.Append("<b>Supplier</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Can</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>MilkInKG</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>MilkInLtr</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>CLR</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>Fat Perc.</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>SNF Perc.</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>TS Perc.</b>");
sb.Append("</td>");
sb.Append("</tr>");
foreach (DataRow row in DS1.Tables[0].Rows)
{
//count1++;
if (rows["_Date"].ToString() == row["_Date"].ToString() && rows["RouteName"].ToString() == row["RouteName"].ToString())
{
if (rows["_Session"].ToString() == row["_Session"].ToString())
{
count++;
countavg += count;
sb.Append("<td colspan='2'>");
sb.Append(row["Supplier"].ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
can = Convert.ToInt32(row["Can"]);
totalcan += can;
sb.Append(can.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
milkinkg = Convert.ToDouble(row["MilkInKG"]);
totalmilkkg += milkinkg;
sb.Append(milkinkg.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
milkinltr = Convert.ToDouble(row["MilkInLtr"]);
totalmilklter += milkinltr;
sb.Append(milkinltr.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
clr = Convert.ToDouble(row["CLRReading"]);
totalclr += clr;
sb.Append(clr.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'> ");
fatpercent = Convert.ToDouble(row["FATPercentage"]);
totalfatpercent += fatpercent;
sb.Append(fatpercent.ToString());
try { fatinkg = Convert.ToDouble(row["FATInKG"]); } catch { fatinkg = 0; }
totalfatinkg += fatinkg;
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
snfpercent = Convert.ToDouble(row["SNFPercentage"]);
totalsnfpercent += snfpercent;
sb.Append(snfpercent.ToString());
try { snfinkg = Convert.ToDouble(row["SNFInKG"]); } catch { snfinkg = 0; }
totalsnfinkg += snfinkg;
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
tspercent = Convert.ToDouble(row["TSPercentage"]);
totaltspercent += tspercent;
sb.Append(tspercent.ToString());
try { tsinkg = Convert.ToDouble(row["TSInKg"]); } catch { tsinkg = 0; }
totaltsinkg += tsinkg;
sb.Append("</td>");
sb.Append("</tr>");
}
}
}
sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '9'> </td> </tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='1'>");
sb.Append("<b>Average :</b> ");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("</td>");
sb.Append("<td style='text-align:right' colspan='5'>");
sb.Append("<b>" + Convert.ToDecimal(totalfatpercent / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totalsnfpercent / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totaltspercent / count).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
//////////////////////////////////////////////////////////////////
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2'>");
sb.Append("<b>Total :" + count + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(totalcan.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(totalmilkkg.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(totalmilklter.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
//sb.Append(totalclr.ToString());
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
ttlfatinkg = ((totalfatpercent / count) * totalmilkkg) / 100;
sb.Append(ttlfatinkg.ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
ttlsnfinkg = ((totalsnfpercent / count) * totalmilkkg) / 100;
sb.Append(ttlsnfinkg.ToString("0.00"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
ttltsinkg = (totaltspercent / count * totalmilkkg) / 100;
sb.Append(ttltsinkg.ToString("0.00"));
sb.Append("</td>");
sb.Append("</tr>");
totfat += ttlfatinkg;
totsnf += ttlsnfinkg;
totmillkg += totalmilkkg;
totmilkltr += totalmilklter;
totcan += totalcan;
totts += ttltsinkg;
totclr += totalclr;
totcount += count;
}
sb.Append("<tr style='border-bottom:1px solid'> <td colspan = '9'> </td> </tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td>");
sb.Append("<b>Count</b>");
sb.Append("</td>");
sb.Append("<td colspan='1'>");
sb.Append("<b>" + totcount + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + totcan + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + totmillkg + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totmilkltr).ToString("00.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + totclr + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totfat).ToString("00.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totsnf).ToString("00.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append("<b>" + Convert.ToDecimal(totts).ToString("00.00") + "</b>");
sb.Append("</td>");
sb.Append("</tr>");
result = sb.ToString();
CheckLists.Text = result;
Session["ctrl"] = pnlCheckList;
}
else
{
result = "No Records Found";
CheckLists.Text = result;
}
uprouteList.Update();
}
protected void btnGeneratereport_Click(object sender, EventArgs e)
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.FomDate = Convert.ToDateTime(txtStartDate.Text);
p.ToDate = Convert.ToDateTime(txtEndDate.Text);
if (Convert.ToInt32(dpVehicleNo.SelectedItem.Value) == 0)
{
p.VehicleNo = "0";
}
else
{
p.VehicleNo = dpVehicleNo.SelectedItem.Value;
}
DataSet DS = new DataSet();
DS = pd.VehiclewiseOperationStatementReport(p);
string result = string.Empty;
if (!Comman.Comman.IsDataSetEmpty(DS))
{
StringBuilder sb = new StringBuilder();
sb.Append("<style type='text / css'>");
sb.Append(".tg { border - collapse:collapse; border - spacing:0; border: none; } .dispnone {display:none;} ");
sb.Append("</style>");
sb.Append("<table class='tg style1' style='page-break-inside:avoid; align:center;'>");
sb.Append("<colgroup>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("<col style = 'width:100px'>");
sb.Append("</colgroup>");
sb.Append("<tr>");
sb.Append("<th class='tg-yw4l' rowspan='2'>");
sb.Append("<img src='/Theme/img/logo1.png' class='img-circle' alt='Logo' width='50px' hight='50px'>");
sb.Append("</th>");
sb.Append("<th class='tg-baqh' colspan='12' style='text-align:center'>");
sb.Append("<b>Nanjil Milk Collection Centre, Mulagumoodu, K.K.Dt.</b>");
sb.Append("</th colspan='3'>");
sb.Append("<th class='tg-yw4l' style='text-align:right'>");
sb.Append("TIN:330761667331<br>");
sb.Append("</th>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td class='tg-yw4l' colspan='12' style='text-align:center'>");
sb.Append("<u>Vehiclewise Opereation Report</u> <br/>");
sb.Append("</td>");
sb.Append("<td class='tg-yw4l' style='text-align:right'>");
sb.Append("PH:248370,248605");
sb.Append("</td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append(" <td colspan='3' style='text-align:left'>");
sb.Append("Date : " + DateTime.Now.ToString());
sb.Append("</td>");
sb.Append("<td colspan='9'>");
//sb.Append(dpVehicleNo.SelectedItem.Text.ToString() + " " + DS.Tables[1].Rows[0]["VehicleType"].ToString());
sb.Append("</td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
sb.Append("<td style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtStartDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td style='text-align:right'>");
sb.Append(Convert.ToDateTime(txtEndDate.Text).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Date</b>");
sb.Append("</td>");
//sb.Append("<td colspan='2' style='text-align:center'>");
//sb.Append("<b>Route</b>");
//sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Vehicle No</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Route</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>MornIn</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>MornOut</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>EveIn</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>EveOut</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>MornCanIn</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>MornCanOut</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>EveCanIn</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>EveCanOut</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>MornKm</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>EveKm</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>Amount</b>");
sb.Append("</td>");
//sb.Append("<td style='text-align:center'>");
//sb.Append("<b>Remark</b>");
//sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
int count = 0;
double MornKm = 0.00;
double totMornKm = 0.00;
double EveKm = 0.00;
double totEveKm = 0.00;
double Amt = 0.00;
double totAmt = 0.00;
foreach (DataRow row in DS.Tables[0].Rows)
{
count++;
sb.Append("<td style='text-align:left'>");
sb.Append(Convert.ToDateTime(row["Date"]).ToString("dd-MM-yyyy"));
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["VehicleNo"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["RouteName"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["MorningInTime"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["MorningOutTime"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["EveningInTime"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["EveningOutTime"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["MorningInCan"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["MorningOutCan"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["EveningInCan"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(row["EveningOutCan"].ToString());
sb.Append("</td>");
sb.Append("<td>");
try { MornKm = Convert.ToDouble(row["MorningKM"]); }
catch { MornKm = 0.00; }
totMornKm += MornKm;
sb.Append(Convert.ToDecimal(MornKm).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td>");
try { EveKm = Convert.ToDouble(row["EveningKM"]); }
catch { EveKm = 0.00; }
totEveKm += EveKm;
sb.Append(Convert.ToDecimal(EveKm).ToString("0.00"));
sb.Append("</td>");
sb.Append("<td>");
try { Amt = Convert.ToDouble(row["Amount"]); }
catch { Amt = 0.00; }
totAmt += Amt;
sb.Append(Convert.ToDecimal(Amt).ToString("0.00"));
sb.Append("</td>");
//sb.Append("<td style='text-align:center'>");
//sb.Append(row["Remarks"].ToString());
//sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("<tr style='border-bottom:1px solid'><td colspan='14'></td></tr>");
sb.Append("<tr style='border-bottom:1px solid'>");
sb.Append("<td colspan='2' style='text-align:left'>");
sb.Append("<b>Total :</b>");
sb.Append("</td>");
sb.Append("<td colspan='9'>");
sb.Append("<b>" + count + "</b>");
sb.Append("</td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
//sb.Append("<td></td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>" + Convert.ToDecimal(totMornKm).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>" + Convert.ToDecimal(totEveKm).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td style='text-align:left'>");
sb.Append("<b>" + Convert.ToDecimal(totAmt).ToString("0.00") + "</b>");
sb.Append("</td>");
sb.Append("<td></td>");
sb.Append("</tr>");
result = sb.ToString();
Payment.Text = result;
Session["ctrl"] = pnlPayment;
}
else
{
result = "No Records Found";
Payment.Text = result;
}
uprouteList.Update();
}
protected void btnShow_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ProcurementData pd = new ProcurementData();
Model.Procurement p = new Model.Procurement();
p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
p.FomDate = Convert.ToDateTime(txtfromdate.Text);
p.ToDate = Convert.ToDateTime(txttodate.Text);
DataSet DS = new DataSet();
DS = pd.GetTransactionDetails(p);
try
{
try
{
DS.Tables[0].PrimaryKey = new[] { DS.Tables[0].Columns["SupplierID"] };
}
catch (Exception) { }
try
{
DS.Tables[2].PrimaryKey = new[] { DS.Tables[2].Columns["SupplierID"] };
}
catch (Exception) { }
try
{
DS.Tables[3].PrimaryKey = new[] { DS.Tables[3].Columns["SupplierID"] };
}
catch (Exception) { }
try
{
DS.Tables[4].PrimaryKey = new[] { DS.Tables[4].Columns["SupplierID"] };
}
catch (Exception) { }
try
{
DS.Tables[5].PrimaryKey = new[] { DS.Tables[5].Columns["SupplierID"] };
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[2], true, MissingSchemaAction.Add);
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[3], false, MissingSchemaAction.Add);
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[4], false, MissingSchemaAction.Add);
}
catch (Exception) { }
try
{
DS.Tables[0].Merge(DS.Tables[5], false, MissingSchemaAction.Add);
}
catch (Exception) { }
try
{
DataSet tds = new DataSet();
//Create transaction details DataTable.
DataTable tbl = new DataTable();
// tbl = ds.Tables.Add("Transaction");
tbl.Columns.Add("SupplierID", typeof(int));
// tbl.PrimaryKey = new DataColumn[] { tbl.Columns["SupplierID"] };
tbl.Columns.Add("SupplierCode", typeof(string));
tbl.Columns.Add("Amount", typeof(decimal));
tbl.Columns.Add("Bonus", typeof(decimal));
tbl.Columns.Add("Scheme", typeof(decimal));
tbl.Columns.Add("RDAmount", typeof(double));
tbl.Columns.Add("CanLoan", typeof(double));
tbl.Columns.Add("CashLoan", typeof(double));
tbl.Columns.Add("BankLoan", typeof(double));
foreach (DataRow row in DS.Tables[0].Rows)
{
foreach (DataRow rows in DS.Tables[1].Rows)
{
if (row["SupplierID"].ToString() == rows["SupplierID"].ToString())
{
DataRow trow = tbl.NewRow();
trow["SupplierID"] = row["SupplierID"];
trow["SupplierCode"] = row["SupplierCode"];
trow["Amount"] = row["Amount"];
trow["Bonus"] = rows["Bonus"];
trow["Scheme"] = rows["Scheme"];
trow["RDAmount"] = row["RDAmount"];
trow["CanLoan"] = row["CanLoan"];
trow["CashLoan"] = row["CashLoan"];
trow["BankLoan"] = row["BankLoan"];
tbl.Rows.Add(trow);
}
}
}
tds.Tables.Add(tbl);
rpRouteList.DataSource = tds;
rpRouteList.DataBind();
//rpBrandInfo.Visible = true;
uprouteList.Update();
foreach (RepeaterItem item in rpRouteList.Items)
{
double amt;
double bonus;
double scheme;
double rd;
double canloan;
double cashloan;
double bankloan;
double netamt;
TextBox txtAmt = item.FindControl("txtAmt") as TextBox;
try { amt = Convert.ToDouble(txtAmt.Text); }
catch { amt = 0.00; }
TextBox txtBonus = item.FindControl("txtBonus") as TextBox;
try { bonus = Convert.ToDouble(txtBonus.Text); }
catch { bonus = 0.00; }
TextBox txtScheme = item.FindControl("txtScheme") as TextBox;
try { scheme = Convert.ToDouble(txtScheme.Text); }
catch { scheme = 0.00; }
TextBox txtRD = item.FindControl("txtRD") as TextBox;
try { rd = Convert.ToDouble(txtRD.Text); }
catch { rd = 0.00; }
TextBox txtcanloan = item.FindControl("txtcanloan") as TextBox;
try { canloan = Convert.ToDouble(txtcanloan.Text); }
catch { canloan = 0.00; }
TextBox txtcashloan = item.FindControl("txtcashloan") as TextBox;
try { cashloan = Convert.ToDouble(txtcashloan.Text); }
catch { cashloan = 0.00; }
TextBox txtbankloan = item.FindControl("txtbankloan") as TextBox;
try { bankloan = Convert.ToDouble(txtbankloan.Text); }
catch { bankloan = 0.00; }
TextBox txtNetAmt = item.FindControl("txtNetAmt") as TextBox;
netamt = 0.00;
netamt = amt - (scheme + rd + canloan + cashloan + bankloan);
txtNetAmt.Text = Convert.ToString(netamt);
}
}
catch (Exception ex)
{
string msg = ex.Message.ToString();
}
}
catch (Exception)
{
rpRouteList.DataSource = null;
rpRouteList.DataBind();
Label1.Visible = true;
uprouteList.Update();
}
}
protected void btnAddMilkCollection_Click(object sender, EventArgs e)
{
try
{
Model.Procurement p = new Model.Procurement();
ProcurementData pd = new ProcurementData();
p.MilkCollectionTransportID = 0;
p.Date = Convert.ToDateTime(txtDate.Text);
p.VehicleNo = dpVehicleNo.SelectedItem.Text;
p.RouteID = Convert.ToInt32(dpRoute.SelectedItem.Value);
p.MorningKM = Convert.ToDouble(txtMorningKM.Text);
p.EveningKM = Convert.ToDouble(txtEveningKM.Text);
p.Bata = Convert.ToDouble(txtBata.Text);
p.InstallmentAmount = Convert.ToDouble(txtAmount.Text);
p.MorningInTime = txtMorningInTime.Text;
p.MorningOutTime = txtMorningOutTime.Text;
p.EveningInTime = txtEveningInTime.Text;
p.EveningOutTime = txtEveningOutTime.Text;
p.MorningInCan = txtMCanIn.Text;
p.MorningOutCan = txtMCanOut.Text;
p.EveningInCan = txtEInCan.Text;
p.EveningOutCan = txtEOutCan.Text;
p.DriverName = txtDriverName.Text;
p.Remarks = txtRemarks.Text;
p.CreatedBy = App_code.GlobalInfo.Userid;
p.Createddate = DateTime.Now.ToString("dd-MM-yyyy");
p.ModifiedBy = App_code.GlobalInfo.Userid;
p.ModifiedDate = DateTime.Now.ToString("dd-MM-yyyy");
p.flag = "Insert";
int Result = 0;
Result = pd.InsertMilkCollectionTransportDetails(p);
if (Result > 0)
{
divDanger.Visible = false;
divwarning.Visible = false;
divSusccess.Visible = true;
lblSuccess.Text = "Milk Collection Transport Record Add Successfully";
ClearTextBox();
string dates = Convert.ToDateTime(txtDate1.Text).ToString("dd-MM-yyyy");
string vehicle = dpVehicleNo1.SelectedItem.Text;
int route = Convert.ToInt32(dpRoute1.SelectedItem.Value);
//BindMilkCollectionList(dates, vehicle, route);
pnlError.Update();
upMain.Update();
uprouteList.Update();
}
else
{
divDanger.Visible = false;
divwarning.Visible = true;
divSusccess.Visible = false;
lblwarning.Text = "Please Contact to Site Admin";
pnlError.Update();
}
}
catch (Exception ex)
{
string msg = ex.Message.ToString();
}
}
