private void RefreshList() { try { using (DLMSEntities db = new DLMSEntities()) { List <Outlet> _Outlet = db.Outlets.OrderBy(d => d.OutletCode).ToList(); ListViewItem item = null; lsvOutlet.Items.Clear(); if (_Outlet != null) { foreach (Outlet oDItem in _Outlet) { item = new ListViewItem(); item.Text = oDItem.OutletCode; item.SubItems.Add(oDItem.OutletName); item.Tag = oDItem; lsvOutlet.Items.Add(item); } lblTotal.Text = "Total :" + _Outlet.Count().ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } bool isNew = false; using (DLMSEntities db = new DLMSEntities()) { if (_ExpenseItem.ExpenseItemID <= 0) { RefreshObject(); _ExpenseItem.ExpenseItemID = db.ExpenseItems.Count() > 0 ? db.ExpenseItems.Max(obj => obj.ExpenseItemID) + 1 : 1; db.ExpenseItems.Add(_ExpenseItem); isNew = true; } else { _ExpenseItem = db.ExpenseItems.FirstOrDefault(obj => obj.ExpenseItemID == _ExpenseItem.ExpenseItemID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!isNew) { if (ItemChanged1 != null) { ItemChanged1(); } this.Close(); } else { if (ItemChanged1 != null) { ItemChanged1(); } _ExpenseItem = new ExpenseItem(); RefreshValue(); txtCode.Text = GenerateCategoryCode(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void fSystemInformation_Load(object sender, EventArgs e) { try { btnPhotoClearCus.Enabled = true; btnEmpPPClear.Enabled = true; btnSuppClear.Enabled = true; using (DLMSEntities db = new DLMSEntities()) { _SystemInformation = (from c in db.SystemInformations where c.SystemInfoID == 1 select c).FirstOrDefault(); if (_SystemInformation != null) { RefreshValue(); } else { _SystemInformation = new BO.SystemInformation(); } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public string GenerateEmpCode() { int i = 0; string sCode = ""; using (DLMSEntities db = new DLMSEntities()) { i = db.Employees.Count(); if (i.ToString().Length == 1) { sCode = "0000" + Convert.ToString(db.Employees.Count() + 1); } else if (i.ToString().Length == 2) { sCode = "000" + Convert.ToString(db.Employees.Count() + 1); } else if (i.ToString().Length == 3) { sCode = "00" + Convert.ToString(db.Employees.Count() + 1); } else if (i.ToString().Length == 4) { sCode = "0" + Convert.ToString(db.Employees.Count() + 1); } else { sCode = "0" + Convert.ToString(db.Employees.Count() + 1); } } return(sCode); }
private void btnDelete_Click(object sender, EventArgs e) { try { Designaiton oDesignation = new Designaiton(); if (lsvDesignation.SelectedItems != null && lsvDesignation.SelectedItems.Count > 0) { oDesignation = (Designaiton)lsvDesignation.SelectedItems[0].Tag; if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { using (DLMSEntities db = new DLMSEntities()) { db.Designaitons.Attach(oDesignation); db.Designaitons.Remove(oDesignation); //Save to database db.SaveChanges(); } RefreshList(); } } else { MessageBox.Show("select an item to Delete", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception Ex) { MessageBox.Show("Cannot delete item due to " + Ex.Message); } }
private void RefreshList() { try { using (DLMSEntities db = new DLMSEntities()) { var _ExpenseItems = db.ExpenseItems; ListViewItem item = null; lsvExpenseIteams.Items.Clear(); _ExpenseItemsList = _ExpenseItems.OrderBy(m => m.Code).ToList(); List <ListViewItem> lItems = new List <ListViewItem>(); if (_ExpenseItemsList != null) { foreach (ExpenseItem grd in _ExpenseItemsList) { item = new ListViewItem(); item.Text = grd.Code; item.SubItems.Add(grd.Description); item.Tag = grd; lsvExpenseIteams.Items.Add(item); } lsvExpenseIteams.Items.AddRange(lItems.ToArray()); lblTotal.Text = "Total :" + _ExpenseItemsList.Count().ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnDelete_Click(object sender, EventArgs e) { try { ExpenseItem oExpenseItem = new ExpenseItem(); if (lsvExpenseIteams.SelectedItems != null && lsvExpenseIteams.SelectedItems.Count > 0) { oExpenseItem = (ExpenseItem)lsvExpenseIteams.SelectedItems[0].Tag; if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { using (DLMSEntities db = new DLMSEntities()) { db.ExpenseItems.Attach(oExpenseItem); db.ExpenseItems.Remove(oExpenseItem); //Save to database db.SaveChanges(); } RefreshList(); } } } catch (Exception Ex) { MessageBox.Show("Cannot delete item due to " + Ex.Message); } }
private string GenerateCategoryCode() { int i = 0; string sCode = ""; using (DLMSEntities db = new DLMSEntities()) { i = db.ExpenseItems.Count(); if (i.ToString().Length == 1) { sCode = "0000" + Convert.ToString(db.ExpenseItems.Count() + 1); } else if (i.ToString().Length == 2) { sCode = "000" + Convert.ToString(db.ExpenseItems.Count() + 1); } else if (i.ToString().Length == 3) { sCode = "00" + Convert.ToString(db.ExpenseItems.Count() + 1); } else if (i.ToString().Length == 4) { sCode = "0" + Convert.ToString(db.ExpenseItems.Count() + 1); } else { sCode = "0" + Convert.ToString(db.ExpenseItems.Count() + 1); } } return(sCode); }
private string GenerateCusCode() { int i = 0; string sCode = ""; using (DLMSEntities db = new DLMSEntities()) { i = db.Customers.Max(id => id.CustomerID); if (i.ToString().Length == 1) { sCode = "0000" + Convert.ToString(i + 1); } else if (i.ToString().Length == 2) { sCode = "000" + Convert.ToString(i + 1); } else if (i.ToString().Length == 3) { sCode = "00" + Convert.ToString(i + 1); } else if (i.ToString().Length == 4) { sCode = "0" + Convert.ToString(i + 1); } else { sCode = "0" + Convert.ToString(i + 1); } } return(sCode); }
private string GenerateOutletCode() { int i = 0; string sCode = ""; using (DLMSEntities db = new DLMSEntities()) { i = db.Outlets.Count(); if (i.ToString().Length == 1) { sCode = "0000" + Convert.ToString(i + 1); } else if (i.ToString().Length == 2) { sCode = "000" + Convert.ToString(i + 1); } else if (i.ToString().Length == 3) { sCode = "00" + Convert.ToString(i + 1); } else if (i.ToString().Length == 4) { sCode = "0" + Convert.ToString(i + 1); } else { sCode = "0" + Convert.ToString(i + 1); } } return(sCode); }
private void RefreshList() { try { using (DLMSEntities db = new DLMSEntities()) { var odesignation = db.Designaitons; ListViewItem item = null; lsvDesignation.Items.Clear(); _designationList = odesignation.OrderBy(m => m.Name).ToList(); List <ListViewItem> lItems = new List <ListViewItem>(); if (_designationList != null) { foreach (Designaiton grd in _designationList) { item = new ListViewItem(); item.Text = grd.Code; item.SubItems.Add(grd.Name); item.Tag = grd; lsvDesignation.Items.Add(item); } lsvDesignation.Items.AddRange(lItems.ToArray()); lblTotal.Text = "Total :" + _designationList.Count().ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { if (!IsValid()) { return; } if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { using (DLMSEntities db = new DLMSEntities()) { if (_Outlet.OutletID <= 0) { RefreshObject(); _Outlet.OutletID = db.Outlets.Count() > 0 ? db.Outlets.Max(obj => obj.OutletID) + 1 : 1; db.Outlets.Add(_Outlet); } else { _Outlet = db.Outlets.FirstOrDefault(obj => obj.OutletID == _Outlet.OutletID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (MessageBox.Show("Do you want to insert another Outlet?", "Insert Outlet", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _Outlet = new Outlet(); RefreshValue(); txtOutletCode.Text = GenerateOutletCode(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void PopulateTranTypeCbo() { using (DLMSEntities db = new DLMSEntities()) { cboExpenseItem.DisplayMember = "Description"; cboExpenseItem.ValueMember = "ExpenseItemID"; cboExpenseItem.DataSource = db.ExpenseItems.OrderBy(x => x.Description).ToList(); } }
private void PopulateOutletName() { using (DLMSEntities db = new DLMSEntities()) { cboOutletName.ValueMember = "OutletID"; cboOutletName.DisplayMember = "OutletName"; cboOutletName.DataSource = db.Outlets.OrderBy(x => x.OutletName).ToList(); } }
private void PopulateDesignationCbo() { using (DLMSEntities db = new DLMSEntities()) { cboDesignation.DisplayMember = "Name"; cboDesignation.ValueMember = "DesignationID"; cboDesignation.DataSource = db.Designaitons.OrderBy(x => x.Name).ToList(); } }
private void button1_Click(object sender, EventArgs e) { DateTime dt = dtpMonth.Value; using (DLMSEntities db = new DLMSEntities()) { pcdExIEpen_ResultBindingSource.DataSource = db.pcdExIEpen(dt).ToList(); reportViewer1.RefreshReport(); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { using (DLMSEntities db = new DLMSEntities()) { if (_Employee.EmployeeID <= 0) { RefreshObject(); _Employee.EmployeeID = db.Employees.Count() > 0 ? db.Employees.Max(obj => obj.EmployeeID) + 1 : 1; db.Employees.Add(_Employee); } else { _Employee = db.Employees.FirstOrDefault(obj => obj.EmployeeID == _Employee.EmployeeID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (MessageBox.Show("Do you want to create another Employee?", "Create Employee", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _Employee = new Employee(); RefreshValue(); txtEmpCode.Text = GenerateEmpCode(); } } } } catch (Exception EX) { MessageBox.Show(EX.Message); } }
public void ShowDlg(Customer oCustomer, bool IsNew) { _Customer = oCustomer; _IsNew = IsNew; PopulateOutletName(); PopulateCustomerStatus(); DLMSEntities db = new DLMSEntities(); _SystemInformation = (from c in db.SystemInformations where c.SystemInfoID == 1 select c).FirstOrDefault(); RefreshValue(); this.ShowDialog(); }
public void ShowDlg(Employee oEmployee, bool IsNew) { _IsNew = IsNew; DLMSEntities db = new DLMSEntities(); var _SysInfos = db.SystemInformations; _SystemInformation = (from c in db.SystemInformations where c.SystemInfoID == 1 select c).FirstOrDefault(); _Employee = oEmployee; PopulateDesignationCbo(); RefreshValue(); this.ShowDialog(); }
private void RefreshList() { try { using (DLMSEntities db = new DLMSEntities()) { if (txtSearch.Text.Length == 0) { _Customers = db.Customers.OrderBy(d => d.Code).ToList(); } else { _Customers = db.Customers.OrderBy(d => d.Code).Where(n => n.Name.StartsWith(txtSearch.Text)).ToList(); } ListViewItem item = null; lsvCustomer.Items.Clear(); string status = ""; if (_Customers != null) { foreach (Customer oDItem in _Customers) { item = new ListViewItem(); item.Text = oDItem.Code; item.SubItems.Add(oDItem.Name); item.SubItems.Add(oDItem.ContactNo); EnumCustomerStatus stat = (EnumCustomerStatus)oDItem.CusStatus; status = stat.ToString(); if (oDItem.CusStatus == 2) { item.BackColor = Color.Red; } item.SubItems.Add(status); item.Tag = oDItem; lsvCustomer.Items.Add(item); } lblTotal.Text = "Total :" + _Customers.Count().ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void RefreshList() { try { using (DLMSEntities db = new DLMSEntities()) { var _Expenditures = db.Expenditures; ListViewItem item = null; lsvExpenditure.Items.Clear(); //_ExpenditureList = _Expenditures.OrderBy(m => m.EntryDate).ToList(); _ExpenditureList = _Expenditures.ToList(); List <ListViewItem> lItems = new List <ListViewItem>(); if (_ExpenditureList != null) { foreach (Expenditure grd in _ExpenditureList) { item = new ListViewItem(); item.Text = grd.EntryDate.ToString(); //item.SubItems.Add(grd.ExpenseItem.ToString()); //string expense = new fExpenditure().expense(); //item.SubItems.Add(expense); int i = grd.ExpenseItemID; //IEnumerable<string> ex = new DLMSEntities().ExpenseItems.Where(m => m.ExpenseItemID == i).Select(n=>n.Description); //item.SubItems.Add(i.ToString()); var ex = new DLMSEntities().ExpenseItems.Where(m => m.ExpenseItemID == i).Select(n => n.Description).FirstOrDefault(); item.SubItems.Add(ex.ToString()); item.SubItems.Add(grd.Purpose); item.SubItems.Add(grd.Amount.ToString()); item.Tag = grd; lsvExpenditure.Items.Add(item); } lsvExpenditure.Items.AddRange(lItems.ToArray()); lblTotal.Text = "Total :" + _ExpenditureList.Count().ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { using (DLMSEntities db = new DLMSEntities()) { if (_SystemInformation.SystemInfoID <= 0) { RefreshObject(); _SystemInformation.SystemInfoID = db.SystemInformations.Count() > 0 ? db.SystemInformations.Max(obj => obj.SystemInfoID) + 1 : 1; db.SystemInformations.Add(_SystemInformation); } else { _SystemInformation = db.SystemInformations.FirstOrDefault(obj => obj.SystemInfoID == _SystemInformation.SystemInfoID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void RefreshList() { try { using (DLMSEntities db = new DLMSEntities()) { //var _Employees = db.Employees; List <Employee> _Employees = db.Employees.OrderBy(e => e.EmpCode).ToList(); ListViewItem item = null; lsvEmployee.Items.Clear(); if (_Employees != null) { foreach (Employee oEmpItem in _Employees) { item = new ListViewItem(); item.Text = oEmpItem.EmpCode; item.SubItems.Add(oEmpItem.EmpName); item.SubItems.Add(oEmpItem.Designaiton.Name); //item.SubItems.Add(oEmpItem.Designation.Description); item.SubItems.Add(oEmpItem.ContactNo); item.Tag = oEmpItem; lsvEmployee.Items.Add(item); } lblTotal.Text = "Total :" + _Employees.Count().ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public fExpenditures() { db = new DLMSEntities(); InitializeComponent(); }
public fExpenseIteams() { db = new DLMSEntities(); InitializeComponent(); }