private void New_Supplier_Load(object sender, EventArgs e) { bool focused = txtSupplierName.Focused; cmbStatus.SelectedIndex = 0; if (Sup_ID != null) { btnSave.Caption = "Update"; Master.Database.SupplierData Sup = new Master.Database.SupplierData(); DataTable dtSup = new DataTable(); Sup.FnConn(); dtSup = Sup.GetRow(Sup_ID); Sup.FnTrans(); if (dtSup.Rows.Count > 0) { txtSupplierName.Text = dtSup.Rows[0]["name"] + ""; txtFullName.Text = dtSup.Rows[0]["fullName"] + ""; memAddr.Text = dtSup.Rows[0]["address"] + ""; txtPhone.Text = dtSup.Rows[0]["phoneNumber"] + ""; txtEmail.Text = dtSup.Rows[0]["email"] + ""; txtWebAddr.Text = dtSup.Rows[0]["webAddress"] + ""; txtLicenseNo.Text = dtSup.Rows[0]["licenceNumber"] + ""; txtTinNo.Text = dtSup.Rows[0]["tinNumber"] + ""; cmbStatus.Text = dtSup.Rows[0]["status"] + ""; txtOppBal.Text = dtSup.Rows[0]["openingBalance"] + ""; txtCreditLimit.Text = dtSup.Rows[0]["creditLimit"] + ""; spnPaymentDays.Text = dtSup.Rows[0]["paymentDays"] + ""; } } }
private void Supplier_List_Load(object sender, EventArgs e) { Master.Database.SupplierData Sup = new Master.Database.SupplierData(); try { Sup.FnConn(); DataTable dt = Sup.FillData(); gridControl1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (Sup_ID != null) { DialogResult rs = MessageBox.Show(" Procced ?", "Alert", MessageBoxButtons.YesNo); if (rs == DialogResult.Yes) { Master.Database.SupplierData Sup = new Master.Database.SupplierData(); Sup.FnConn(); Sup.DeleteData(Sup_ID); Sup.FnTrans(); Clear(); } } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { New_Supplier a = new New_Supplier(null); a.ShowDialog(); Master.Database.SupplierData Sup = new Master.Database.SupplierData(); try { Sup.FnConn(); DataTable dt = Sup.FillData(); gridControl1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void repositoryItemCheckEdit1_CheckedChanged(object sender, EventArgs e) { DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle); string Sup_ID = row["supplierId"].ToString(); New_Supplier NewSup = new New_Supplier(Sup_ID); NewSup.ShowDialog(); Master.Database.SupplierData Sup = new Master.Database.SupplierData(); try { Sup.FnConn(); DataTable dt = Sup.FillData(); gridControl1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { bool focused = txtSupplierName.Focused; cmbStatus.SelectedIndex = 0; int slno = 0; if (txtSupplierName.Text != "" && memAddr.Text != "" && txtPhone.Text != "") { Master.Database.SupplierData Sup = new Master.Database.SupplierData(); Sup.SupplierName = txtSupplierName.Text; Sup.FullName = txtFullName.Text; Sup.Address = memAddr.Text; Sup.Phone = txtPhone.Text; Sup.Email = txtEmail.Text; Sup.WebAddr = txtWebAddr.Text; Sup.License = txtLicenseNo.Text; Sup.TinNo = txtTinNo.Text; Sup.Status = cmbStatus.Text; Sup.OppBal = txtOppBal.Text; Sup.CreditLimit = txtCreditLimit.Text; Sup.PaymentDays = (spnPaymentDays.Text).Split('.')[0]; if (btnSave.Caption == "Save") { Sup.FnConn(); slno = Convert.ToInt16(Sup.GetMaxValue()) + 1; Sup.FnTrans(); Sup.Supplierid = "SUP000" + slno; Sup.FnConn(); Sup.fnTransactionData("I"); Sup.FnTrans(); if (Sup.Result == "Success") { MessageBox.Show("Supplier Created", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Supplier Creation failed", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { Sup.Supplierid = Sup_ID; Sup.FnConn(); Sup.fnTransactionData("U"); Sup.FnTrans(); if (Sup.Result == "Success") { MessageBox.Show("Suppler Details Updated..", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Information); } } Clear(); } else { MessageBox.Show("Please input mandatory fields"); } }