private void btnAddContact_Click(object sender, RoutedEventArgs e)
{
try
{
if (btnAddContact.Content.ToString() != "Add")
{
if (lblContact.Content == "?" || String.IsNullOrWhiteSpace(txtContact.Text))
{
System.Windows.MessageBox.Show("Please input correct format and/or fill all required fields");
return;
}
}
if (btnAddContact.Content.ToString() == "Add")
{
grpContact.Visibility = Visibility.Visible;
btnAddContact.Content = "Save";
btnEdtContact.Content = "Cancel";
btnEdtContact.IsEnabled = true;
btnDelContact.Visibility = Visibility.Hidden;
tbAddress.IsEnabled = false;
tbContact.IsEnabled = false;
tbInfo.IsEnabled = false;
}
else if (btnAddContact.Content.ToString() == "Save")
{
//for view
if (status == "View")
{
using (var ctx = new finalContext())
{
int ctr = ctx.AgentContacts.Count() + 1;
AgentContact con = new AgentContact { AgentID = aId, CNumber = ctr, Contact = txtContact.Text };
ctx.AgentContacts.Add(con);
ctx.SaveChanges();
var cts = from ct in ctx.AgentContacts
where ct.AgentID == aId
select new { ContactNumberID = ct.CNumber, Contact = ct.Contact };
dgContact.ItemsSource = cts.ToList();
}
reset();
return;
}
using (var ctx = new finalContext())
{
int ctr = ctx.TempAgentContact.Count() + 1;
TempAgentContact con = new TempAgentContact { CNumber = ctr, Contact = txtContact.Text };
ctx.TempAgentContact.Add(con);
ctx.SaveChanges();
var cts = from ct in ctx.TempAgentContact
select new { ContactNumberID = ct.CNumber, Contact = ct.Contact };
dgContact.ItemsSource = cts.ToList();
}
reset();
}
else
{
//for view
if (status == "View")
{
using (var ctx = new finalContext())
{
int num = Convert.ToInt32(getRow(dgContact, 0));
var con = ctx.AgentContacts.Where(x => x.CNumber == num && x.AgentID == aId).First();
con.Contact = txtContact.Text;
ctx.SaveChanges();
var cts = from ct in ctx.AgentContacts
where ct.AgentID == aId
select new { ContactNumberID = ct.CNumber, Contact = ct.Contact };
dgContact.ItemsSource = cts.ToList();
}
reset();
return;
}
using (var ctx = new finalContext())
{
int num = Convert.ToInt32(getRow(dgContact, 0));
var con = ctx.TempAgentContact.Where(x => x.CNumber == num).First();
con.Contact = txtContact.Text;
ctx.SaveChanges();
var cts = from ct in ctx.TempAgentContact
select new { ContactNumberID = ct.CNumber, Contact = ct.Contact };
dgContact.ItemsSource = cts.ToList();
reset();
}
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("Runtime Error: " + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
if (lblFName.Content == "?" || lblLName.Content == "?" || lblMI.Content == "?" || lblEmail.Content == "?" || lblSuffix.Content == "?"
|| String.IsNullOrWhiteSpace(txtFName.Text) || String.IsNullOrWhiteSpace(txtLName.Text))
{
System.Windows.MessageBox.Show("Please input correct format and/or fill all required fields");
return;
}
if (status == "Add")
{
DialogResult dr = System.Windows.Forms.MessageBox.Show("Are you sure you want to add this record?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == System.Windows.Forms.DialogResult.No)
{
return;
}
if (txtFName.Text == "" || txtLName.Text == "")
{
System.Windows.MessageBox.Show("Please complete the required information", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
if (!Regex.IsMatch(txtFName.Text, @"^[a-zA-Z]+$"))
{
}
using (var ctx = new finalContext())
{
Agent agt = new Agent { FirstName = txtFName.Text, LastName = txtLName.Text, Suffix = txtSuffix.Text, MI = txtMI.Text, Active = true, Email = txtEmail.Text, Photo = ConvertImageToByteArray(selectedFileName) };
var query = from con in ctx.TempAgentAddresses
select con;
foreach (var item in query)
{
AgentAddress add = new AgentAddress { AddressNumber=item.AddressNumber, Street = item.Street, City = item.City, Province = item.Province };
ctx.AgentAddresses.Add(add);
}
var query1 = from con in ctx.TempAgentContact
select con;
foreach (var item in query1)
{
AgentContact con = new AgentContact { CNumber=item.CNumber, Contact = item.Contact };
ctx.AgentContacts.Add(con);
}
AuditTrail at = new AuditTrail { EmployeeID = UserID, DateAndTime = DateTime.Now, Action = "Added new Agent " + agt.FirstName + " " + agt.MI + " " + agt.LastName + " " + agt.Suffix};
ctx.AuditTrails.Add(at);
ctx.Agents.Add(agt);
ctx.SaveChanges();
System.Windows.MessageBox.Show("Added New Agent");
this.Close();
}
}
else
{
DialogResult dr = System.Windows.Forms.MessageBox.Show("Are you sure you want to update this record?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == System.Windows.Forms.DialogResult.No)
{
return;
}
using (var ctx = new finalContext())
{
var agt = ctx.Agents.Find(aId);
agt.FirstName = txtFName.Text;
agt.LastName = txtLName.Text;
agt.Suffix = txtSuffix.Text;
agt.MI = txtMI.Text;
agt.Email = txtEmail.Text;
if (isChanged == true)
{
agt.Photo = ConvertImageToByteArray(selectedFileName);
}
AuditTrail at = new AuditTrail { EmployeeID = UserID, DateAndTime = DateTime.Now, Action = "Updated Agent " + agt.FirstName + " " + agt.MI + " " + agt.LastName + " " + agt.Suffix };
ctx.AuditTrails.Add(at);
ctx.SaveChanges();
System.Windows.MessageBox.Show("Agent Updated", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("Runtime Error: " + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}