private void New_Warranty_Claim_Load(object sender, EventArgs e)
{
if (claimeNo != null)
{
warrenty.FnConn();
barButtonItem1.Caption = "Update";
DataTable dt = warrenty.FillData("search", "spWarrenty", claimeNo);
if (dt.Rows.Count > 0)
{
txtclaimeno.Text = dt.Rows[0]["claimNo"] + "";
Commen_Form.Functions.DateConverter dc = new Commen_Form.Functions.DateConverter();
dtpdate.Text = dc.dateconverter(dt.Rows[0]["date"] + "");
txtcontactName.Text = dt.Rows[0]["contactName"] + "";
txtContactNo.Text = dt.Rows[0]["contactNumber"] + "";
txtmailId.Text = dt.Rows[0]["mailid"] + "";
dtpurchaseDate.Text = dc.dateconverter(dt.Rows[0]["purchaseDate"] + "");
txtItemNamae.Text = dt.Rows[0]["itemName"] + "";
txtmodelName.Text = dt.Rows[0]["modelNo"] + "";
txtSerialNumber.Text = dt.Rows[0]["serialNo"] + "";
txtcomplaintDeatails.Text = dt.Rows[0]["complaintDetails"] + "";
cmbstatus.Text = dt.Rows[0]["status"] + "";
warrenty.FnTrans();
}
}
else
{
loadnewForm();
}
}
private void Proforma_Invoice_Load(object sender, EventArgs e)
{
if (proinvoiceno != null)
{
txtinvoice.Text = proinvoiceno;
Sale.Database.PerformanceInvoiceData p2 = new Sale.Database.PerformanceInvoiceData();
p2.FnConn();
DataSet ds = p2.FillDataSet("searchgrid", proinvoiceno, "spperformanceInvoice");
DataTable inv = ds.Tables[0];
DataTable invgrid = ds.Tables[1];
p2.FnTrans();
if (inv.Rows.Count > 0)
{
Commen_Form.Functions.DateConverter dc = new Commen_Form.Functions.DateConverter();
dtpdate.EditValue = dc.dateconverter(inv.Rows[0]["date"] + "");
txtbillto.Text = inv.Rows[0]["billto"] + "";
txtbilladdress.Text = inv.Rows[0]["billaddress"] + "";
txtshipto.Text = inv.Rows[0]["shipto"] + "";
txtshipaddress.Text = inv.Rows[0]["shipaddress"] + "";
txtnotes.Text = inv.Rows[0]["note"] + "";
txtsubtotal.Text = inv.Rows[0]["sutotal"] + "";
txttax.Text = inv.Rows[0]["tax"] + "";
txtship.Text = inv.Rows[0]["shipping"] + "";
txtgrandtotal.Text = inv.Rows[0]["grandtotal"] + "";
barButtonItem1.Enabled = false;
}
if (invgrid.Rows.Count > 0)
{
gridControl1.DataSource = invgrid;
}
}
else
{
Sale.Database.PerformanceInvoiceData pi = new Sale.Database.PerformanceInvoiceData();
pi.FnConn();
DataTable dt = pi.FillData("M", "", "spperformanceInvoice");
pi.FnTrans();
if (dt.Rows.Count > 0)
{
int number = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1;
string num = number + "";
num = "PRI/" + num.PadLeft(5, '0');
txtinvoice.Text = num;
}
dtpdate.EditValue = DateTime.Now;
DataTable dt3 = new DataTable();
dt3.Columns.Add("slno", Type.GetType("System.Int32"));
dt3.Columns.Add("pinvoice_no", Type.GetType("System.String"));
dt3.Columns.Add("itemCode", Type.GetType("System.String"));
dt3.Columns.Add("description", Type.GetType("System.String"));
dt3.Columns.Add("quantity", Type.GetType("System.Double"));
dt3.Columns.Add("unitPrice", Type.GetType("System.Double"));
dt3.Columns.Add("amount", Type.GetType("System.Double"));
dt3.Columns.Add("status", Type.GetType("System.String"));
gridControl1.DataSource = dt3;
}
}
private void New_RFQ_Load(object sender, EventArgs e)
{
Test.Purchase.database.Rfq pr = new Purchase.database.Rfq();
pr.FnConn();
DataTable dt1 = pr.FillData("M", "");
DataTable dt = new DataTable();
if (dt1.Rows.Count > 0)
{
int number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1;
string invoiceno = number + "";
txtRFQNO.Text = "RFQ-NO:" + invoiceno.PadLeft(5, '0');
}
dt.Columns.Add("slno", Type.GetType("System.Int32"));
dt.Columns.Add("description", Type.GetType("System.String"));
dt.Columns.Add("brand", Type.GetType("System.String"));
dt.Columns.Add("quantity", Type.GetType("System.Int32"));
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
gridControl1.DataSource = dt;
cmbVendor1.Properties.Items.Clear();
cmbVendor2.Properties.Items.Clear();
cmbVendor3.Properties.Items.Clear();
DataTable dtc1 = pr.FillData("SC", "");
foreach (DataRow dr1 in dtc1.Rows)
{
cmbVendor1.Properties.Items.Add(dr1["name"] + "");
cmbVendor2.Properties.Items.Add(dr1["name"] + "");
cmbVendor3.Properties.Items.Add(dr1["name"] + "");
}
String res = pr.FnTrans();
Test.Purchase.database.PurchaseRequest pr1 = new Purchase.database.PurchaseRequest();
pr1.FnConn();
DataTable dtd = pr1.FillData("updatedata", no);
DataTable dtg = pr1.FillData("updategrd", no);
gridControl1.DataSource = dtg;
txtPO.Text = dtd.Rows[0]["prNo"].ToString();
Test.Commen_Form.Functions.DateConverter c = new Commen_Form.Functions.DateConverter();
dateRFQdate.EditValue = c.dateconverter(dtd.Rows[0]["date"] + "");
txtLocation.Text = dtd.Rows[0]["location"] + "";
}
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 Purchase_Requst_Load(object sender, EventArgs e)
{
Test.Purchase.database.PurchaseRequest pr = new Purchase.database.PurchaseRequest();
pr.FnConn();
if (flag == true)
{
btnSave.Caption = "Update";
DataTable dt = pr.FillData("updatedata", no);
DataTable dt1 = pr.FillData("updategrd", no);
gridControl1.DataSource = dt1;
txtLocation.Text = dt.Rows[0]["location"] + "";
txtPRNo.Text = dt.Rows[0]["prNo"] + "";
txtRequester.Text = dt.Rows[0]["requester"] + "";
Test.Commen_Form.Functions.DateConverter c = new Commen_Form.Functions.DateConverter();
datePOdate.EditValue = c.dateconverter(dt.Rows[0]["date"] + "");
}
else
{
btnSave.Caption = "Save";
DataTable dt1 = pr.FillData("M", "");
String res = pr.FnTrans();
DataTable dt = new DataTable();
if (dt1.Rows.Count > 0)
{
number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1;
string invoiceno = number + "";
txtPRNo.Text = "PR/" + invoiceno.PadLeft(5, '0');
}
dt.Columns.Add("slno", Type.GetType("System.Int32"));
dt.Columns.Add("itemNo", Type.GetType("System.String"));
dt.Columns.Add("description", Type.GetType("System.String"));
dt.Columns.Add("brand", Type.GetType("System.String"));
dt.Columns.Add("quantity", Type.GetType("System.Int32"));
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
gridControl1.DataSource = dt;
datePOdate.EditValue = DateTime.Now;
}
}
private void New_PO_Load(object sender, EventArgs e)
{
txtTotal.Text = "0.00";
Test.Purchase.database.PurchaseOrder po = new Purchase.database.PurchaseOrder();
po.FnConn();
RepositoryItemComboBox riCombo = new RepositoryItemComboBox();
DataTable dtc = po.FillData("loadUnit", "");
foreach (DataRow row in dtc.Rows)
{
riCombo.Items.Add(row["um"]);
}
persistentRepository1.Items.Add(riCombo);
gridControl1.ExternalRepository = persistentRepository1;
DataTable dt1 = po.FillData("M", "");
DataTable dt = new DataTable();
datePOdate.EditValue = DateTime.Now;
if (dt1.Rows.Count > 0)
{
int number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1;
string invoiceno = number + "";
txtPO.Text = "PO-NO:" + invoiceno.PadLeft(5, '0');
}
DataTable dtv = po.FillData("SC", "");
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
if (dtv.Rows.Count > 0)
{
for (int i = 0; i < dtv.Rows.Count; i++)
{
collection.Add(dtv.Rows[i]["name"].ToString());
}
}
txtVendor.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtVendor.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtVendor.MaskBox.AutoCompleteCustomSource = collection;
if (flag == true)
{
DataTable dtd = po.FillData("updatedata", no);
DataTable dtg = po.FillData("updategrd", no);
String res = po.FnTrans();
(gridControl1.MainView as GridView).Columns["um"].ColumnEdit = riCombo;
dtg.Columns.Add("um", Type.GetType("System.String"));
dtg.Columns.Add("unitprice", Type.GetType("System.Double"));
dtg.Columns.Add("amount", Type.GetType("System.Double"));
dtg.Columns.Add("taxpercent", Type.GetType("System.Double"));
dtg.Columns.Add("taxamount", Type.GetType("System.Double"));
dtg.Columns.Add("total", Type.GetType("System.Double"));
gridControl1.DataSource = dtg;
datePOdate.EditValue = DateTime.Now;
txtPRNo.Text = dtd.Rows[0]["purchaseOrderNo"] + "";
txtRFQNo.Text = dtd.Rows[0]["rfqNo"] + "";
txtrequester.Text = dtd.Rows[0]["requester"] + "";
txtLocation.Text = dtd.Rows[0]["location"] + "";
Test.Commen_Form.Functions.DateConverter c = new Commen_Form.Functions.DateConverter();
datePOdate.EditValue = c.dateconverter(dtd.Rows[0]["date"] + "");
}
else
{
dt.Columns.Add("slno", Type.GetType("System.Int32"));
dt.Columns.Add("itemCode", Type.GetType("System.String"));
dt.Columns.Add("description", Type.GetType("System.String"));
dt.Columns.Add("brand", Type.GetType("System.String"));
(gridControl1.MainView as GridView).Columns["um"].ColumnEdit = riCombo;
dt.Columns.Add("quantity", Type.GetType("System.Double"));
dt.Columns.Add("um", Type.GetType("System.String"));
dt.Columns.Add("unitprice", Type.GetType("System.Double"));
dt.Columns.Add("amount", Type.GetType("System.Double"));
dt.Columns.Add("taxpercent", Type.GetType("System.Double"));
dt.Columns.Add("taxamount", Type.GetType("System.Double"));
dt.Columns.Add("total", Type.GetType("System.Double"));
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
gridControl1.DataSource = dt;
}
}
private void Delivery_Note_Load(object sender, EventArgs e)
{
salesDeliveryData.FnConn();
DataTable dt = salesDeliveryData.FillData("S", "", "spCustomer");
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
collection.Add(dt.Rows[i]["name"].ToString());
}
}
txtCustomerName.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtCustomerName.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtCustomerName.MaskBox.AutoCompleteCustomSource = collection;
if (deliveryNoteNo != null)
{
barButtonItem1.Enabled = false;
barButtonItem5.Enabled = true;
DataSet ds = salesDeliveryData.FillDataSet("searchgrid", deliveryNoteNo, "spsalesDelivery");
DataTable tab = ds.Tables[0];
salesDeliveryData.FnTrans();
if (tab.Rows.Count > 0)
{
txtdeliveryNo.Text = tab.Rows[0]["deliveryNo"] + "";
Commen_Form.Functions.DateConverter dc = new Commen_Form.Functions.DateConverter();
dtpdate.EditValue = dc.dateconverter(tab.Rows[0]["date"] + "");
txtsalesPerson.Text = tab.Rows[0]["salesPerson"] + "";
txtCustomerName.Text = tab.Rows[0]["customerName"] + "";
txtaddress.Text = tab.Rows[0]["address"] + "";
txtemail.Text = tab.Rows[0]["contact"] + "";
DataTable gridData = ds.Tables[1];
gridControl1.DataSource = gridData;
}
}
else
{
dtpdate.EditValue = DateTime.Now;
barButtonItem5.Enabled = false;
DataTable dt1 = salesDeliveryData.FillData("M", "", "spsalesDelivery");
if (dt1.Rows.Count > 0)
{
int slno = Convert.ToInt32(dt1.Rows[0][0].ToString()) + 1;
string deno = slno + "";
txtdeliveryNo.Text = "DLN/" + deno.PadLeft(5, '0');
}
DataTable dt3 = new DataTable();
dt3.Columns.Add("slno", Type.GetType("System.Int32"));
dt3.Columns.Add("deliveryNo", Type.GetType("System.String"));
dt3.Columns.Add("barcode", Type.GetType("System.String"));
dt3.Columns.Add("description", Type.GetType("System.String"));
dt3.Columns.Add("quantity", Type.GetType("System.Double"));
dt3.Columns.Add("status", Type.GetType("System.String"));
gridControl1.DataSource = dt3;
salesDeliveryData.FnTrans();
}
}
public void LoadData()
{
if (ProdCode != null)
{
ProductData Prod = new ProductData();
Prod.FnConn();
DataTable dtProd = new DataTable();
dtProd = Prod.GetRow(ProdCode);
if (FormName == "Product")
{
btnSave.Caption = "Update";
Commen_Form.Functions.DateConverter Conv = new Commen_Form.Functions.DateConverter();
if (dtProd.Rows.Count > 0)
{
txtProduct_code.Text = dtProd.Rows[0]["productCode"] + "";
txtQRCode.Text = dtProd.Rows[0]["qrCode"] + "";
txtItem_name.Text = dtProd.Rows[0]["itemName"] + "";
cmbUnit.Text = dtProd.Rows[0]["unitMeasure"] + "";
cmbBrand_name.Text = dtProd.Rows[0]["brandName"] + "";
cmbItem_category.Text = dtProd.Rows[0]["category"] + "";
cmbTax_category.Text = dtProd.Rows[0]["taxCategory"] + "";
cmbPurchase_Tax.Text = dtProd.Rows[0]["taxOnPurchase"] + "";
cmbSales_tax.Text = dtProd.Rows[0]["taxOnSale"] + "";
txtPurchase_rate.Text = dtProd.Rows[0]["purchaseRate"] + "";
txtOpening_stock.Text = dtProd.Rows[0]["openingStock"] + "";
txtReorder_qty.Text = dtProd.Rows[0]["reorderQuantity"] + "";
txtMin_qty.Text = dtProd.Rows[0]["minimumQuantity"] + "";
txtSales_rate1.Text = dtProd.Rows[0]["salesRate1"] + "";
txtSales_rate2.Text = dtProd.Rows[0]["salesRate2"] + "";
txtSales_rate3.Text = dtProd.Rows[0]["salesRate3"] + "";
txtBatch_name.Text = dtProd.Rows[0]["batchName"] + "";
dtMfg_date.Text = Conv.dateconverter(dtProd.Rows[0]["mfgDate"] + "");
dtExp_date.Text = Conv.dateconverter(dtProd.Rows[0]["expDate"] + "");
memWarranty.Text = dtProd.Rows[0]["warrentyDetails"] + "";
cmbLocation.Text = dtProd.Rows[0]["location"] + "";
}
}
else
{
if (dtProd.Rows.Count > 0)
{
txtProduct_code.Text = "ID-C:000000" + (Convert.ToInt16(Prod.GetMaxValue()) + 1);
txtQRCode.Text = dtProd.Rows[0]["qrCode"] + "";
txtItem_name.Text = dtProd.Rows[0]["itemName"] + "";
cmbUnit.Text = dtProd.Rows[0]["unitMeasure"] + "";
cmbBrand_name.Text = dtProd.Rows[0]["brandName"] + "";
cmbItem_category.Text = dtProd.Rows[0]["category"] + "";
txtPurchase_rate.Text = PurRate;
txtOpening_stock.Text = Qty;
txtReorder_qty.Text = dtProd.Rows[0]["reorderQuantity"] + "";
txtMin_qty.Text = dtProd.Rows[0]["minimumQuantity"] + "";
txtBatch_name.Text = BatchID;
Pdt_No = dtProd.Rows[0]["productCode"] + "";
}
}
Prod.FnTrans();
}
else
{
btnDelete.Enabled = false;
}
}