private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (String.IsNullOrEmpty(cardnametb.Text))
{
MessageBox.Show("Please enter card type name");
}
else
{
ImusCityHallEntities db = new ImusCityHallEntities();
IdentificationCardType card = db.IdentificationCardTypes.Find(id);
card.CardType = cardnametb.Text;
db.SaveChanges();
var audit = new AuditTrailModel
{
Activity = "Updated an item in identification card list. CARD ID : " + id.ToString(),
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Card updated successfully!");
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
IdentificationCardType card = db.IdentificationCardTypes.Find(id);
cardnametb.Text = card.CardType;
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (!String.IsNullOrEmpty(cardnametb.Text))
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (db.IdentificationCardTypes.Any(m => m.CardType == cardnametb.Text))
{
MessageBox.Show("Card name is already used");
}
else
{
IdentificationCardType card = new IdentificationCardType();
card.CardType = cardnametb.Text;
card.IsActive = true;
card.DateAdded = DateTime.Now;
db.IdentificationCardTypes.Add(card);
db.SaveChanges();
var audit = new AuditTrailModel
{
Activity = "Added new identification card type in the database. CARD NAME: " + cardnametb.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("New type of card inserted in the database");
}
}
else
{
MessageBox.Show("Please type in the card type name");
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (String.IsNullOrEmpty(firstnametb.Text))
{
MessageBox.Show("Please enter firs name");
}
else if (String.IsNullOrEmpty(lastnametb.Text))
{
MessageBox.Show("Please enter last name");
}
else if (String.IsNullOrEmpty(bdaydp.Text))
{
MessageBox.Show("Please enter birthdate");
}
else if (String.IsNullOrEmpty(compaddresstb.Text))
{
MessageBox.Show("Please enter complete address");
}
else
{
ImusCityHallEntities db = new ImusCityHallEntities();
ImusCityGovernmentSystem.Model.Customer customer = db.Customers.Find(id);
customer.FirstName = firstnametb.Text;
customer.MiddleName = string.IsNullOrEmpty(middlenamebt.Text) ? null : middlenamebt.Text;
customer.LastName = lastnametb.Text;
customer.DateAdded = DateTime.Now;
customer.AddedBy = App.EmployeeID;
customer.CompleteAddress = compaddresstb.Text;
customer.Birthdate = bdaydp.SelectedDate;
customer.IsActive = true;
foreach (var list in gd.Where(m => m.IsSelected == true))
{
if (db.CustomerIdentificationCards.Any(m => m.CustomerID == customer.CustomerID && m.IdentificationCardTypeID == list.Id))
{
CustomerIdentificationCard custCard = db.CustomerIdentificationCards.FirstOrDefault(m => m.CustomerID == customer.CustomerID && m.IdentificationCardTypeID == list.Id);
custCard.IdentificationNumber = list.CardNumber;
db.SaveChanges();
}
else
{
CustomerIdentificationCard custCard = new CustomerIdentificationCard();
IdentificationCardType card = db.IdentificationCardTypes.Find(list.Id);
custCard.CustomerID = customer.CustomerID;
custCard.IdentificationCardTypeID = list.Id;
custCard.IdentificationNumber = list.CardNumber;
db.CustomerIdentificationCards.Add(custCard);
db.SaveChanges();
}
}
foreach (var list in gd.Where(m => m.IsSelected == false))
{
if (db.CustomerIdentificationCards.Any(m => m.CustomerID == customer.CustomerID && m.IdentificationCardTypeID == list.Id))
{
CustomerIdentificationCard custCard = db.CustomerIdentificationCards.FirstOrDefault(m => m.CustomerID == customer.CustomerID && m.IdentificationCardTypeID == list.Id);
db.CustomerIdentificationCards.Remove(custCard);
db.SaveChanges();
}
}
db.SaveChanges();
MessageBox.Show("Customer updated");
var audit = new AuditTrailModel
{
Activity = "Updated customer in the database. CUSTOMER ID: " + id.ToString(),
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
