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(); } }