private void salesinvoice_Load(object sender, EventArgs e)
{
butRemoveItem.Visible = true;
butAdditem.Visible = true;
dtpdate.Value = DateTime.Now;
txtCustcode.Text = "C";
txtitemcode.Text = "I";
panel2.Visible = false;
Purchase.PurchaseDetails purChaseDetailObj = new Purchase.PurchaseDetails();
vendorDetails = purChaseDetailObj.GetVendorDetaisInDataTable();
ItemDetails = purChaseDetailObj.GetItemPriceAndNameDetaisInDataTable();
setAutoCompleteMode(txtproductname, "ItemName", ItemDetails);
setAddToCraftTable();
string selectquery = "select invoiceid from salesinvoice";
DataTable dt3 = d.getDetailByQuery(selectquery);
string id = "";
foreach (DataRow dr in dt3.Rows)
{
id = dr[0].ToString();
}
if (id == "")
{
id = "1";
txtSrNo.Text = id;
}
else
{
int t = Convert.ToInt32(id);
int t1 = t + 1;
txtSrNo.Text = t1.ToString();
}
}
private void Form7_Load(object sender, EventArgs e)
{
txtdate.Value = DateTime.Now;
string stlect = "select Deliveryid from CustomerOrderDelivery";
DataTable dt = dbMainClass.getDetailByQuery(stlect);
string id = "";
foreach (DataRow dr in dt.Rows)
{
id = dr[0].ToString();
}
//txtSrNo.Text = id;
if (id == "")
{
id = "1";
txtSrNo.Text = id;
}
else
{
int txt = Convert.ToInt32(id);
int txt1 = txt + 1;
txtSrNo.Text = txt1.ToString();
}
panel2.Visible = false;
Purchase.PurchaseDetails purChaseDetailObj = new Purchase.PurchaseDetails();
vendorDetails = purChaseDetailObj.GetVendorDetaisInDataTable();
ItemDetails = purChaseDetailObj.GetItemPriceAndNameDetaisInDataTable();
setAutoCompleteMode(txtProductName, "ItemName", ItemDetails);
setAddToCraftTable();
}
private void salesdelivary_Load(object sender, EventArgs e)
{
txtItemCode.Text = "I";
dtpDate.Value = DateTime.Now;
txtcustomercode.Text = "C";
panel2.Visible = false;
Purchase.PurchaseDetails purChaseDetailObj = new Purchase.PurchaseDetails();
vendorDetails = purChaseDetailObj.GetVendorDetaisInDataTable();
ItemDetails = purChaseDetailObj.GetItemPriceAndNameDetaisInDataTable();
setAutoCompleteMode(txtProductName, "ItemName", ItemDetails);
setAddToCraftTable();
string selectquery = "select Delivaryid from salesOrderDelivery ";
DataTable dt3 = d.getDetailByQuery(selectquery);
string id = "";
foreach (DataRow dr in dt3.Rows)
{
id = dr[0].ToString();
}
if (id == "")
{
id = "1";
txtSrNo.Text = id;
}
else
{
int t = Convert.ToInt32(id);
int t1 = t + 1;
txtSrNo.Text = t1.ToString();
}
}
private void PurchaseOrder_Load(object sender, EventArgs e)
{
dtpDate.Value = DateTime.Now;
panel2.Visible = false;
SqlConnection con = dbMainClass.openConnection();
string stlect = "select Orderid from VendorOrderDetails";
DataTable dt = dbMainClass.getDetailByQuery(stlect);
string id = "";
foreach (DataRow dr in dt.Rows)
{
id = dr[0].ToString();
}
//txtSrNo.Text = id;
if (id == "")
{
//int txt = Convert.ToInt32(id);
//int txt1 = txt + 1;
id = "1";
txtSrNo.Text = id;
}
else
{
int txt = Convert.ToInt32(id);
int txt1 = txt + 1;
txtSrNo.Text = txt1.ToString();
}
Purchase.PurchaseDetails purChaseDetailObj = new Purchase.PurchaseDetails();
vendorDetails = purChaseDetailObj.GetVendorDetaisInDataTable();
ItemDetails = purChaseDetailObj.GetItemPriceAndNameDetaisInDataTable();
setAutoCompleteMode(txtProductName, "ItemName", ItemDetails);
setAddToCraftTable();
//setAutoCompleteMode(txtVendorName, "Name", vendorDetails);
}
