private void Sales_Return_Load(object sender, EventArgs e) { Commen_Form.Functions.DateConverter dc = new Commen_Form.Functions.DateConverter(); if (Invoiceno != "") { txtinvoiceno.Text = Invoiceno; Sale.Database.SalesData salesData = new Sale.Database.SalesData(); salesData.FnConn(); DataSet ds = salesData.FillDataSet("select", Invoiceno, "spsales"); DataTable inv = ds.Tables[0]; DataTable invgrid = ds.Tables[1]; DataTable max = salesData.FillData("M", "", "spsalesReturn"); if (max.Rows.Count > 0) { returnno = (Convert.ToInt32(max.Rows[0][0] + "") + 1) + ""; } if (invgrid.Rows.Count > 0) { //invgrid.Columns.Add("retqty"); for (int i = 0; i < invgrid.Rows.Count; i++) { invgrid.Rows[i]["returnNO"] = returnno; invgrid.Rows[i]["retqty"] = "0"; } gridControl1.DataSource = invgrid; } if (inv.Rows.Count > 0) { if (inv.Rows[0]["type"] + "" == "Credit") { toggleSwitch1.IsOn = true; type = "Credit"; } else { toggleSwitch1.IsOn = false; type = "Cash"; } CustomerId = inv.Rows[0]["customerid"] + ""; txtcustomername.Text = inv.Rows[0]["customerName"] + ""; txtaddress.Text = inv.Rows[0]["address"] + ""; txtphone.Text = inv.Rows[0]["phone"] + ""; dtpdate.Text = dc.dateconverter(inv.Rows[0]["date"] + ""); txtnetamount.Text = inv.Rows[0]["netTotal"] + ""; payamount.Text = inv.Rows[0]["payAmount"] + ""; txtsalesperson.Text = inv.Rows[0]["salesPerson"] + ""; } } }
private void Sales_Invoice_Load(object sender, EventArgs e) { typecash.IsOn = true; cmbpaymentmode.SelectedIndex = 0; Test.Sale.Database.SalesData sales = new Sale.Database.SalesData(); sales.FnConn(); DataTable dt1 = sales.FillData("M", "", "spsales"); if (dt1.Rows.Count > 0) { int number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1; string invoiceno = number + ""; txtinvoice.Text = "INV/" + invoiceno.PadLeft(5, '0'); } DataTable dt2 = sales.FillData("S", "", "spCustomer"); if (dt2.Rows.Count > 0) { for (int i = 0; i < dt2.Rows.Count; i++) { try { cmbcustomer.Properties.Items.Add(dt2.Rows[i]["name"].ToString()); } catch (Exception ex) { } } } dtpdate.EditValue = DateTime.Now; String res = sales.FnTrans(); DataTable dt = new DataTable(); dt.Columns.Add("slno", Type.GetType("System.Int32")); dt.Columns.Add("invoice_no", Type.GetType("System.String")); dt.Columns.Add("barcode", Type.GetType("System.String")); dt.Columns.Add("itemcode", Type.GetType("System.String")); dt.Columns.Add("description", Type.GetType("System.String")); dt.Columns.Add("brandName", Type.GetType("System.String")); dt.Columns.Add("quantity", Type.GetType("System.Double")); dt.Columns.Add("offer", Type.GetType("System.Double")); dt.Columns.Add("unitPrice", Type.GetType("System.Double")); dt.Columns.Add("amount", Type.GetType("System.Double")); dt.Columns.Add("discountPercent", Type.GetType("System.Double")); dt.Columns.Add("discountAmount", Type.GetType("System.Double")); dt.Columns.Add("taxPercent", Type.GetType("System.Double")); dt.Columns.Add("taxAmount", Type.GetType("System.Double")); dt.Columns.Add("totalAmount", Type.GetType("System.Double")); DataRow dr = dt.NewRow(); dt.Rows.Add(dr); gridControl1.DataSource = dt; if (deliveryno != null) { sales.FnConn(); DataSet ds = sales.FillDataSet("searchgrid", deliveryno, "spsalesDelivery"); sales.FnTrans(); DataTable delivery = ds.Tables[0]; DataTable deliverygrid = ds.Tables[1]; if (delivery.Rows.Count > 0) { CustomerId = delivery.Rows[0]["customerid"] + ""; cmbcustomer.Text = delivery.Rows[0]["customerName"] + ""; txtaddress.Text = delivery.Rows[0]["address"] + ""; // txtphone.Text = delivery.Rows[0]["contact"] + ""; txtsalesperson.Text = delivery.Rows[0]["salesPerson"] + ""; dt.Clear(); sales.FnConn(); for (int i = 0; i < deliverygrid.Rows.Count; i++) { string barcode = deliverygrid.Rows[i]["barcode"] + ""; double qty = Convert.ToDouble(deliverygrid.Rows[i]["quantity"] + ""); if (barcode != null) { DataTable dts = sales.FillData("barcodedatails", barcode, "spQuatation"); if (dts.Rows.Count > 0) { string itemCode = dts.Rows[0]["productCode"] + ""; string description = dts.Rows[0]["itemName"] + ""; string brandName = dts.Rows[0]["brandName"] + ""; double unitprice = Convert.ToDouble(dts.Rows[0]["salesRate1"] + ""); double totalprice = unitprice * qty; dt.Rows.Add(i + 1, "", barcode, itemCode, description, brandName, qty, "1", unitprice, totalprice, 0, 0, 0, 0, totalprice); } } } sales.FnTrans(); calculateTotal(); } } }