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