private void fnClear() { txt_BillNo.Text = ""; txt_EmailAddress.Text = ""; txt_MobilNo.Text = ""; txt_Name.Text = ""; txt_OrderNo.Text = ""; txt_PrdNm.Text = ""; txt_Qty.Text = ""; txt_Rate.Text = ""; txt_Value.Text = ""; txt_Remarks.Text = ""; Chk_Delivered.Checked = false; txt_Address.Text = ""; lbl_Gst.Text = "0.00"; lbl_RoundOff.Text = "0.00"; lbl_Taxable.Text = "0.00"; //lbl_Advance.Text = "Advance Received : 0.00"; lbl_Total.Text = "0.00"; txt_Discount.Text = "0.00"; dat_BillDate.Text = DateTime.Now.ToString(); //.ToString("dd/MM/yyyy"); dat_ProofDate.Text = DateTime.Now.AddDays(1).ToString(); // DateTime.Now.ToString("dd/MM/yyyy"); dat_DeliveryDate.Text = DateTime.Now.AddDays(7).ToString(); //.ToString("dd/MM/yyyy"); dat_DeliveredDate.Text = DateTime.Now.ToString(); paymnt = new PaymentDetails(); fnGetBilNo(); OrderDtls_DS.Clear(); _RefKey = 0; isOrderClosed = false; lbl_Balance.Visible = false; }
private void metroButton2_Click(object sender, EventArgs e) { this.paymentDetails = null; this.Close(); }
private void fnGetData() { DataSet HdrXML = new DataSet(); OleDbCommand OledbCmd = new OleDbCommand(); OleDbDataAdapter OledbAdp = new OleDbDataAdapter(); try { OledbCmd.Connection = CommonClass.fnGetConnection(); OledbCmd.CommandTimeout = 0; OledbCmd.CommandType = CommandType.StoredProcedure; OledbCmd.CommandText = "PrcBillSystem"; OledbCmd.Parameters.Add("@Action", "S"); OledbCmd.Parameters.Add("@HdrXML", DBNull.Value); OledbCmd.Parameters.Add("@GrdXML", DBNull.Value); OledbCmd.Parameters.Add("@DocPk", _RefKey); OledbAdp.SelectCommand = OledbCmd; OledbAdp.Fill(HdrXML); int docRef = _RefKey; fnClear(); _RefKey = docRef; txt_BillNo.Text = HdrXML.Tables[0].Rows[0]["InvBilNo"].ToString(); txt_EmailAddress.Text = HdrXML.Tables[0].Rows[0]["InvEmailId"].ToString(); txt_MobilNo.Text = HdrXML.Tables[0].Rows[0]["InvMobNo"].ToString(); txt_Name.Text = HdrXML.Tables[0].Rows[0]["InvCusNm"].ToString(); txt_OrderNo.Text = HdrXML.Tables[0].Rows[0]["InvOrdNo"].ToString(); txt_Remarks.Text = HdrXML.Tables[0].Rows[0]["InvRmks"].ToString(); txt_Address.Text = HdrXML.Tables[0].Rows[0]["Add"].ToString(); lbl_Gst.Text = HdrXML.Tables[0].Rows[0]["InvVAT"].ToString(); txt_Discount.Text = HdrXML.Tables[0].Rows[0]["Dis"].ToString(); lbl_RoundOff.Text = HdrXML.Tables[0].Rows[0]["Rnd"].ToString(); lbl_Taxable.Text = HdrXML.Tables[0].Rows[0]["InvGross"].ToString(); lbl_Total.Text = HdrXML.Tables[0].Rows[0]["InvNett"].ToString(); dat_ProofDate.Text = HdrXML.Tables[0].Rows[0]["InvProfDt"].ToString(); dat_BillDate.Text = HdrXML.Tables[0].Rows[0]["InvBilDt"].ToString(); dat_DeliveryDate.Text = HdrXML.Tables[0].Rows[0]["InvDelDt"].ToString(); dat_DeliveredDate.Text = HdrXML.Tables[0].Rows[0]["DelyDt"].ToString(); isOrderClosed = Convert.ToBoolean(HdrXML.Tables[0].Rows[0]["DelySt"]); if (isOrderClosed == true) { Chk_Delivered.Checked = true; } else { Chk_Delivered.Checked = false; } lbl_Balance.Text = string.Format("Balance Amount : {0}", HdrXML.Tables[0].Rows[0]["Bal"].ToString()); lbl_Balance.Visible = true; paymnt = new PaymentDetails(); paymnt.AmountPaid = Convert.ToDecimal(HdrXML.Tables[0].Rows[0]["InvAmntRcvd"].ToString()); //txt_Bal.Text = HdrXML.Tables[0].Rows[0]["Bal"].ToString(); foreach (DataRow dRow in HdrXML.Tables[1].Rows) { OrderDtls_DS.Tables[0].ImportRow(dRow); } dataGridView1.DataSource = OrderDtls_DS.Tables[0].DefaultView; dataGridView1.Refresh(); } catch { } finally { HdrXML.Dispose(); HdrXML = null; OledbCmd.Dispose(); OledbCmd = null; OledbAdp.Dispose(); OledbAdp = null; } }
private void btn_Save_Click(object sender, EventArgs e) { String ErrMsg = ""; if (txt_Name.Text == "") { ErrMsg = ErrMsg + "Customer Name Cannot be Empty. \n"; } if (txt_MobilNo.Text == "") { ErrMsg = ErrMsg + "Mobile No Cannot be Empty. \n"; } if (txt_BillNo.Text == "") { ErrMsg = ErrMsg + "Bill No Cannot be Empty. \n"; } if (OrderDtls_DS.Tables[0].Rows.Count == 0) { ErrMsg = ErrMsg + "Product Details Cannot be Empty. \n"; } if (isOrderClosed && _RefKey != 0) { ErrMsg = ErrMsg + "Cannot update the deliverd orders, Contact Administrator. \n"; } if (!string.IsNullOrEmpty(ErrMsg)) { MetroMessageBox.Show(this, ErrMsg, "Error - Billing System"); return; } frmReceiveAmount frm = new frmReceiveAmount(); if (paymnt == null) { paymnt = new PaymentDetails(); } paymnt.AmountReceived = 0; paymnt.TotalAmount = string.IsNullOrEmpty(lbl_Total.Text) ? 0 : Convert.ToDecimal(lbl_Total.Text); frm.paymentDetails = paymnt; frm.ShowDialog(); if (frm == null || frm.paymentDetails == null) { return; } paymnt = frm.paymentDetails; DataSet HdrXML = new DataSet(); OleDbCommand OledbCmd = new OleDbCommand(); try { HdrXML.Tables.Add(); HdrXML.Tables.Add(new DataTable()); HdrXML.Tables[0].Columns.Add("CusNm", typeof(string)); HdrXML.Tables[0].Columns.Add("MobNo", typeof(string)); HdrXML.Tables[0].Columns.Add("EmailId", typeof(string)); HdrXML.Tables[0].Columns.Add("OrdNo", typeof(string)); HdrXML.Tables[0].Columns.Add("ProfDt", typeof(string)); HdrXML.Tables[0].Columns.Add("DelDt", typeof(string)); HdrXML.Tables[0].Columns.Add("BilNo", typeof(string)); HdrXML.Tables[0].Columns.Add("BilDt", typeof(string)); HdrXML.Tables[0].Columns.Add("Rmks", typeof(string)); HdrXML.Tables[0].Columns.Add("AmntRcvd", typeof(decimal)); HdrXML.Tables[0].Columns.Add("DelySts", typeof(int)); HdrXML.Tables[0].Columns.Add("DelyDt", typeof(string)); HdrXML.Tables[0].Columns.Add("Add", typeof(string)); HdrXML.Tables[0].Columns.Add("Dis", typeof(decimal)); HdrXML.Tables[0].Columns.Add("CGST", typeof(decimal)); HdrXML.Tables[0].Columns.Add("SGST", typeof(decimal)); HdrXML.Tables[0].Columns.Add("Rnd", typeof(decimal)); HdrXML.Tables[0].Columns.Add("CashAmnt", typeof(decimal)); HdrXML.Tables[0].Columns.Add("CardAmnt", typeof(decimal)); HdrXML.Tables[0].Columns.Add("Transfer", typeof(decimal)); HdrXML.Tables[0].Columns.Add("WriteOff", typeof(decimal)); //txt_AmtRcvd String CusNm = "", MobNo = "", EmailId = "", OrdNo = "", ProfDt = "", DelDt = "", BilNo = "", BilDt = "", Rmks = "", DelyDt = "", Address = ""; decimal AmntRcvd = 0, Discount = 0, CGST = 0, SGST = 0, Rnd = 0, CashAmnt = 0, CardAmnt = 0, Transfer = 0, WriteOff = 0; int DelySts = 0; CusNm = txt_Name.Text; MobNo = txt_MobilNo.Text; EmailId = txt_EmailAddress.Text; OrdNo = txt_OrderNo.Text; BilNo = txt_BillNo.Text; Rmks = txt_Remarks.Text; ProfDt = dat_ProofDate.Text; DelDt = dat_DeliveryDate.Text; BilDt = dat_BillDate.Text; DelyDt = dat_DeliveredDate.Text; Address = txt_Address.Text; DelySts = (Chk_Delivered.Checked == true ? 1 : 0); CashAmnt = paymnt.Cash; CardAmnt = paymnt.Card; Transfer = paymnt.NetTransfer; WriteOff = paymnt.WriteOff; AmntRcvd = paymnt.AmountReceived; Discount = string.IsNullOrEmpty(txt_Discount.Text) ? 0 : Math.Round(Convert.ToDecimal(txt_Discount.Text), 2); Rnd = string.IsNullOrEmpty(lbl_RoundOff.Text) ? 0 : Math.Round(Convert.ToDecimal(lbl_RoundOff.Text), 2); CGST = Convert.ToDecimal(OrderDtls_DS.Tables[0].AsEnumerable().Sum(row => Convert.ToDecimal(row["CGST"]))); SGST = Convert.ToDecimal(OrderDtls_DS.Tables[0].AsEnumerable().Sum(row => Convert.ToDecimal(row["SGST"]))); if (DelySts == 1 && paymnt.Balance > 0) { MetroMessageBox.Show(this, "Delivered Order Needs to pay the full amount", "Error - Billing System"); return; } // Header Details if (HdrXML != null) { HdrXML.Tables[0].Rows.Add(CusNm, MobNo, EmailId, OrdNo, ProfDt, DelDt, BilNo, BilDt, Rmks, AmntRcvd, DelySts, DelyDt, Address, Discount, CGST, SGST, Rnd, CashAmnt, CardAmnt, Transfer, WriteOff); } foreach (DataColumn dCol in HdrXML.Tables[0].Columns) { dCol.ColumnMapping = MappingType.Attribute; } // GridDetails foreach (DataColumn dCol in OrderDtls_DS.Tables[0].Columns) { dCol.ColumnMapping = MappingType.Attribute; } OledbCmd.Connection = CommonClass.fnGetConnection(); OledbCmd.CommandTimeout = 0; OledbCmd.CommandType = CommandType.StoredProcedure; OledbCmd.CommandText = "PrcBillSystem"; if (_RefKey == 0) { OledbCmd.Parameters.Add("@Action", "A"); } else { OledbCmd.Parameters.Add("@Action", "E"); } OledbCmd.Parameters.Add("@HdrXML", HdrXML.GetXml()); OledbCmd.Parameters.Add("@GrdXML", OrderDtls_DS.GetXml()); OledbCmd.Parameters.Add("@DocPk", _RefKey); _RefKey = Convert.ToInt32(OledbCmd.ExecuteScalar()); if (MetroMessageBox.Show(this, "Saved Sucessfully, You want to generate Invoice Print", "Billing System", MessageBoxButtons.YesNo) == DialogResult.Yes) { fnPrint(); } fnClear(); _RefKey = 0; } catch (Exception E) { MetroMessageBox.Show(this, E.Message, "Error - Billing System"); } finally { HdrXML.Dispose(); HdrXML = null; OledbCmd.Dispose(); OledbCmd = null; } }