private void dataGridViewCompany_SelectionChanged(object sender, EventArgs e)
{
try
{
var id = Convert.ToInt32(dataGridViewCompany.CurrentRow.Cells[0].Value.ToString());
using (var _context = new STLxEntities())
{
var source = _context.Companies.FirstOrDefault(i => i.Id == id);
if (!string.IsNullOrEmpty(source.Code))
{
TextBoxCode.Text = source.Code;
TextBoxName.Text = source.Name;
ButtonEdit.Enabled = true;
ButtonDelete.Enabled = true;
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
private void BindCompanyWithDataGrid()
{
try
{
using (var _context = new STLxEntities())
{
var source = _context.Companies.Where(e => e.Name.Contains(TextBoxSearch.Text) &&
e.Status != false &&
e.IsDelete != true);
dataGridViewCompany.DataSource = source.ToList();
}
}
catch (Exception)
{
return;
}
}
private void ButtonDelete_Click(object sender, EventArgs e)
{
try
{
using (var _context = new STLxEntities())
{
var emp = _context.Companies.First(i => i.Code == TextBoxCode.Text);
emp.IsDelete = true;
_context.SaveChanges();
BindCompanyWithDataGrid();
MessageBox.Show("Company was deleted");
}
}
catch (Exception)
{
MessageBox.Show("No company is deleted, Contact Admin.");
}
}
private void EditCompany()
{
try
{
using (var _context = new STLxEntities())
{
var company = _context.Companies.First(e => e.Code == TextBoxCode.Text);
company.Code = TextBoxCode.Text;
company.Name = TextBoxName.Text;
company.Status = "YES".Equals(ComboBoxStatus.Text.Trim());
_context.SaveChanges();
ResetControls();
MessageBox.Show("Company was updated");
}
}
catch (Exception)
{
MessageBox.Show("Error on editing company.");
}
}
private void SaveCompany()
{
try
{
using (var _context = new STLxEntities())
{
var company = new Data.Company()
{
Code = TextBoxCode.Text,
Name = TextBoxName.Text,
Status = true,
IsDelete = false
};
_context.Companies.Add(company);
_context.SaveChanges();
ResetControls();
MessageBox.Show("Company Save");
}
}
catch (Exception)
{
MessageBox.Show("Company not save");
}
}
public WithoutBankAccount()
{
_context = new STLxEntities();
}