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();
}
