private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (payeecb.SelectedValue == null)
{
MessageBox.Show("Please select payee");
}
else
{
ImusCityHallEntities db = new ImusCityHallEntities();
PayeeRepresentative representative = db.PayeeRepresentatives.Find(id);
representative.FirstName = fnametb.Text;
representative.MiddleName = mnametb.Text;
representative.LastName = lnametb.Text;
representative.MobileNo = mobilenotb.Text;
representative.Landline = landlinetb.Text;
representative.PayeeID = (int)payeecb.SelectedValue;
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
Mouse.OverrideCursor = Cursors.Wait;
if (String.IsNullOrEmpty(fnametb.Text) || String.IsNullOrEmpty(lnametb.Text))
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please input first name and last name field!");
}
else if (String.IsNullOrEmpty(mobilenotb.Text))
{
MessageBox.Show("Please input mobile number");
}
else
{
ImusCityHallEntities db = new ImusCityHallEntities();
PayeeRepresentative pr = new PayeeRepresentative();
pr.FirstName = fnametb.Text;
pr.MiddleName = mnametb.Text;
pr.LastName = lnametb.Text;
pr.MobileNo = mobilenotb.Text;
pr.Landline = landlinetb.Text;
db.PayeeRepresentatives.Add(pr);
db.SaveChanges();
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Added new payee representative in the database. NAME: " + fnametb.Text + " " + lnametb.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Representative addedd successfully!");
SystemClass.ClearTextBoxes(this);
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
PayeeRepresentative representative = db.PayeeRepresentatives.Find(id);
fnametb.Text = representative.FirstName;
mnametb.Text = representative.MiddleName;
lnametb.Text = representative.LastName;
mobilenotb.Text = representative.MobileNo;
landlinetb.Text = representative.Landline;
payeecb.SelectedValue = representative.PayeeID;
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (gd.Where(m => m.IsSelected == true).Count() == 0)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please select at least representative for the payee!");
}
else if (String.IsNullOrEmpty(payeenotb.Text) || String.IsNullOrEmpty(companynametb.Text) || String.IsNullOrEmpty(companyaddresstb.Text))
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please input company name, company address and payee number");
}
else
{
ImusCityGovernmentSystem.Model.Payee payee = db.Payees.Find(PayeeID);
payee.PayeeNo = payeenotb.Text;
payee.CompanyName = companynametb.Text;
payee.CompanyAddress = companyaddresstb.Text;
payee.TIN = tinnotb.Text;
payee.LandlineNo = contactnotb.Text;
db.SaveChanges();
foreach (var list in gd)
{
if (list.IsSelected == true)
{
PayeeRepresentative pr = db.PayeeRepresentatives.Find(list.Id);
pr.PayeeID = payee.PayeeID;
db.SaveChanges();
}
else
{
PayeeRepresentative pr = db.PayeeRepresentatives.Find(list.Id);
pr.PayeeID = null;
db.SaveChanges();
}
}
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Updated an item in payee list. PAYEE ID: " + PayeeID.ToString(),
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Payee updated successfully!");
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (SystemClass.CheckConnection())
{
if (String.IsNullOrEmpty(payeenotb.Text) || String.IsNullOrEmpty(companynametb.Text) || String.IsNullOrEmpty(companyaddresstb.Text))
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please input company name, company address and payee number");
}
else if (gd.Where(m => m.IsSelected == true).Count() == 0)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please select at least one representative for the payee!");
}
else
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (db.Payees.FirstOrDefault(m => m.PayeeNo == payeenotb.Text) != null)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Payee number already exist!");
}
else
{
ImusCityGovernmentSystem.Model.Payee payee = new Model.Payee();
payee.PayeeNo = payeenotb.Text;
payee.CompanyName = companynametb.Text;
payee.CompanyAddress = companyaddresstb.Text;
payee.TIN = tinnotb.Text;
payee.LandlineNo = contactnotb.Text;
payee.IsActive = true;
db.Payees.Add(payee);
db.SaveChanges();
foreach (var list in gd.Where(m => m.IsSelected == true))
{
PayeeRepresentative pr = db.PayeeRepresentatives.Find(list.Id);
pr.PayeeID = payee.PayeeID;
db.SaveChanges();
}
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Added new payee in the database. PAYEE NO." + payeenotb.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Payee added successfully!");
SystemClass.ClearTextBoxes(this);
LoadPayeeRepresentative();
}
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}
