public void BindComboBoxgetSalesmanName() { DataTable dt = SalesManDetailsController.getSalesmanDetails(); Utility.BindComboBoxEmptyDataSelect(cmbSalesmanName, dt, "SalesmanId", "SalesmanName"); }
private void btnDelete_Click(object sender, EventArgs e) { try { if (salesmanId == 0) { if (Utility.Langn == "English") { MessageBox.Show("Please Select Salesman from list..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("कृपया लिस्ट मधून सेल्समन निवडा ..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } return; } SalesmanDetails sales = new SalesmanDetails(); sales.SalesmanId = salesmanId; sales.SalesmanName = txtSalesmanName.Text.Trim(); sales.Address = txtAdd1.Text.Trim(); if (txtMobileNo.Text == string.Empty) { sales.MobileNo = ""; } else { sales.MobileNo = Utility.ParseValueI(txtMobileNo.Text).ToString(); } sales.DOB = dtpDOB.Value; sales.GenderId = cmbGender.Text; sales.EmailId = txtEmailID.Text.Trim(); sales.addedOn = Utility.firstDate; sales.addedBy = Utility.LoginID; sales.isDelete = 1; DialogResult ShowReport = DialogResult.No; if (Utility.Langn == "English") { ShowReport = MessageBox.Show("Do you want to delete this Record..?", "Delete", MessageBoxButtons.YesNo); } else { ShowReport = MessageBox.Show("माहिती डिलीट करायची का ..?", "डिलीट", MessageBoxButtons.YesNo); } if (ShowReport == DialogResult.Yes) { int i = SalesManDetailsController.addSalesmanDetails(sales); if (i > 0) { if (Utility.Langn == "English") { MessageBox.Show("Deleted Record Successfully ..!", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("माहिती डिलीट झाली ..!", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); } btnnew_Click(sender, e); } else { if (Utility.Langn == "English") { MessageBox.Show("Please You can't delete this salesman ", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("कृपया हा सेल्समन डिलीट करता येत नाही ", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); } return; } } else { ShowReport = DialogResult.No; btnnew_Click(sender, e); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void BindSalesmanGrid() { try { grdSalesmanDetails.DataSource = null; DataTable lstsalesmanDetails = SalesManDetailsController.getSalesmanDetails(); grdSalesmanDetails.AutoGenerateColumns = false; grdSalesmanDetails.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; grdSalesmanDetails.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; grdSalesmanDetails.Font = new Font("Tahoma", 11); grdSalesmanDetails.EnableHeadersVisualStyles = false; grdSalesmanDetails.ColumnCount = 7; if (Utility.Langn == "English") { grdSalesmanDetails.Columns[0].Name = "SalesmanId"; grdSalesmanDetails.Columns[0].HeaderText = "SalesmanId"; grdSalesmanDetails.Columns[0].DataPropertyName = "SalesmanId"; grdSalesmanDetails.Columns[0].Visible = false; grdSalesmanDetails.Columns[1].Name = "SalesmanName"; grdSalesmanDetails.Columns[1].HeaderText = "Salesman Name"; grdSalesmanDetails.Columns[1].DataPropertyName = "SalesmanName"; grdSalesmanDetails.Columns[2].Name = "Address"; grdSalesmanDetails.Columns[2].HeaderText = "Address"; grdSalesmanDetails.Columns[2].DataPropertyName = "Address"; grdSalesmanDetails.Columns[3].Name = "MobileNo"; grdSalesmanDetails.Columns[3].HeaderText = "MobileNo"; grdSalesmanDetails.Columns[3].DataPropertyName = "MobileNo"; grdSalesmanDetails.Columns[4].Name = "GenderId"; grdSalesmanDetails.Columns[4].HeaderText = "Gender"; grdSalesmanDetails.Columns[4].DataPropertyName = "GenderId"; grdSalesmanDetails.Columns[5].Name = "DOB"; grdSalesmanDetails.Columns[5].HeaderText = "DOB"; grdSalesmanDetails.Columns[5].DataPropertyName = "DOB"; grdSalesmanDetails.Columns[5].DefaultCellStyle.Format = "dd-MM-yyyy"; grdSalesmanDetails.Columns[6].Name = "EmailId"; grdSalesmanDetails.Columns[6].HeaderText = "EmailId"; grdSalesmanDetails.Columns[6].DataPropertyName = "EmailId"; } else { grdSalesmanDetails.Columns[0].Name = "SalesmanId"; grdSalesmanDetails.Columns[0].HeaderText = "SalesmanId"; grdSalesmanDetails.Columns[0].DataPropertyName = "SalesmanId"; grdSalesmanDetails.Columns[0].Visible = false; grdSalesmanDetails.Columns[1].Name = "SalesmanName"; grdSalesmanDetails.Columns[1].HeaderText = "ग्राहकाचे नाव"; grdSalesmanDetails.Columns[1].DataPropertyName = "SalesmanName"; grdSalesmanDetails.Columns[2].Name = "Address"; grdSalesmanDetails.Columns[2].HeaderText = "पत्ता"; grdSalesmanDetails.Columns[2].DataPropertyName = "Address"; grdSalesmanDetails.Columns[3].Name = "customerMobileNo"; grdSalesmanDetails.Columns[3].HeaderText = "मोबाईल क्र."; grdSalesmanDetails.Columns[3].DataPropertyName = "customerMobileNo"; grdSalesmanDetails.Columns[4].Name = "GenderId"; grdSalesmanDetails.Columns[4].HeaderText = "लिंग"; grdSalesmanDetails.Columns[4].DataPropertyName = "GenderId"; grdSalesmanDetails.Columns[5].Name = "DOB"; grdSalesmanDetails.Columns[5].HeaderText = "जन्मदिनांक"; grdSalesmanDetails.Columns[5].DataPropertyName = "DOB"; grdSalesmanDetails.Columns[5].DefaultCellStyle.Format = "dd-MM-yyyy"; grdSalesmanDetails.Columns[6].Name = "EmailId"; grdSalesmanDetails.Columns[6].HeaderText = "ई-मेल"; grdSalesmanDetails.Columns[6].DataPropertyName = "EmailId"; } grdSalesmanDetails.DataSource = lstsalesmanDetails; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { SalesmanDetails sales = new SalesmanDetails(); if (txtSalesmanName.Text == string.Empty) { if (Utility.Langn == "English") { MessageBox.Show("Please Add Salesman name ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("कृपया सेल्समन नाव भरा ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } txtSalesmanName.Focus(); return; } sales.SalesmanId = salesmanId; sales.SalesmanName = txtSalesmanName.Text.Trim(); sales.Address = txtAdd1.Text.Trim(); if (txtMobileNo.Text == string.Empty) { sales.MobileNo = ""; } else { sales.MobileNo = Utility.ParseValueI(txtMobileNo.Text).ToString(); } sales.DOB = dtpDOB.Value; sales.GenderId = cmbGender.Text; sales.EmailId = txtEmailID.Text.Trim(); sales.addedOn = Utility.firstDate; sales.addedBy = Utility.LoginID; sales.isDelete = 0; if (sales.SalesmanId > 0) { DialogResult ShowReport = DialogResult.No; if (Utility.Langn == "English") { ShowReport = MessageBox.Show("Do you want to update....?", "", MessageBoxButtons.YesNo); } else { ShowReport = MessageBox.Show("तु्म्हाला अपडेट करायचं का ....?", "", MessageBoxButtons.YesNo); } if (ShowReport == DialogResult.Yes) { int i = SalesManDetailsController.addSalesmanDetails(sales); if (i > 0) { if (Utility.Langn == "English") { MessageBox.Show("Information updated successfully ..!", "update", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("माहिती यशस्वीरित्या अपडेट केली गेली ..!", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information); } btnnew_Click(sender, e); } if (i < 0) { if (Utility.Langn == "English") { MessageBox.Show("Customer Name already exists in list..!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("सेल्समनचे नाव आधीच उपलब्ध आहे ..!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } else { ShowReport = DialogResult.No; btnnew_Click(sender, e); } } else { int i = SalesManDetailsController.addSalesmanDetails(sales); if (i > 0) { if (Utility.Langn == "English") { MessageBox.Show("Information saved successfully ..!", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("माहिती यशस्वीरित्या साठवली गेली ..!", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } btnnew_Click(sender, e); } if (i < 0) { if (Utility.Langn == "English") { MessageBox.Show("Customer Name already exists in list..!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("सेल्समनचे नाव आधीच उपलब्ध आहे ..!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }