private void btnAddContactInfo_Click(object sender, EventArgs e)
{
using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0))
{
Individual CurrentContact = (Individual)individualBindingSource.Current;
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Individuals.Attach(CurrentContact);
Dbconnection.ContactDetails.Attach(frm.CurrentDetail);
CurrentContact.ContactDetails.Add(frm.CurrentDetail);
Dbconnection.SaveChanges();
Dbconnection.Entry(frm.CurrentDetail).Reference("LookupContactType").Load();
};
this.refreshContactDetails();
}
}
}
private void btnUpdateContactDetials_Click(object sender, EventArgs e)
{
using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0))
{
ContactDetail CurrentDetail = (ContactDetail)contactDetailBindingSource.Current;
frm.CurrentDetail = CurrentDetail;
frm.ContactDetailID = CurrentDetail.ContactDetailID;
Individual CurrentContact = (Individual)individualBindingSource.Current;
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.ContactDetails.Attach(CurrentDetail);
Dbconnection.Entry(CurrentDetail).State = EntityState.Modified;
Dbconnection.SaveChanges();
Dbconnection.Entry(frm.CurrentDetail).Reference("LookupContactType").Load();
};
this.refreshContactDetails();
}
}
}
private void btnAddContactDetail_Click(object sender, EventArgs e)
{
using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0))
{
Individual CurrentContact = (Individual)((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Individuals.FirstOrDefault <Individual>();
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Individuals.Attach(CurrentContact);
ContactDetail Con = new ContactDetail
{
ContactTypeID = frm.CurrentDetail.ContactTypeID,
ContactDetailValue = frm.CurrentDetail.ContactDetailValue
};
Dbconnection.ContactDetails.Attach(frm.CurrentDetail);
Dbconnection.Entry(frm.CurrentDetail).Reference(a => a.LookupContactType).Load();
CurrentContact.ContactDetails.Add(frm.CurrentDetail);
Dbconnection.SaveChanges();
};
// refreshInProgressEnquiry(CurrentSelectedEnquiryID);
}
}
}
private void btnAddNewContactDetails_Click(object sender, EventArgs e)
{
if (CurrentEnquiry.Individuals.Count > 0)
{
frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0);
Individual CurrentContact = CurrentEnquiry.Individuals.FirstOrDefault <Individual>();
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Individuals.Attach(CurrentContact);
Dbconnection.ContactDetails.Attach(frm.CurrentDetail);
CurrentContact.ContactDetails.Add(frm.CurrentDetail);
Dbconnection.SaveChanges();
Dbconnection.Entry(frm.CurrentDetail).Reference("LookupContactType").Load();
};
this.refreshContactDetails();
}
}
}
private void btnUpdateContactDetials_Click(object sender, EventArgs e)
{
frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(((ContactDetail)contactDetailBindingSource.Current).ContactDetailID);
frm.CurrentDetail = (ContactDetail)contactDetailBindingSource.Current;
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.ContactDetails.Attach(frm.CurrentDetail);
Dbconnection.Entry(frm.CurrentDetail).State = System.Data.Entity.EntityState.Modified;
Dbconnection.SaveChanges();
};
this.refreshCompanyContactDetails();
}
}
private void btnUpdateCompmayContactDetail_Click(object sender, EventArgs e)
{
if (this.companyContactDetailsBindingSource.Count > 0)
{
CompanyContactDetails CD = (CompanyContactDetails)companyContactDetailsBindingSource.Current;
ContactDetail CDFromCache = CurrentlySelectedCompany.ContactDetails.Where(a => a.ContactDetailID == CD.ContactDetailID).First();
using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(CD.ContactDetailID))
{
frm.CurrentDetail = CDFromCache;
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
CDFromCache.ContactDetailValue = frm.CurrentDetail.ContactDetailValue;
}
refreshCompanyContactDetails();
}
}
}
private void btnuUpdateContactDetails_Click(object sender, EventArgs e)
{
using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(((ContactDetail)contactDetailsInprogressBindingSource.Current).ContactDetailID))
{
frm.CurrentDetail = (ContactDetail)contactDetailsInprogressBindingSource.Current;
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.ContactDetails.Attach(frm.CurrentDetail);
Dbconnection.Entry(frm.CurrentDetail).State = System.Data.Entity.EntityState.Modified;
Dbconnection.SaveChanges();
};
contactDetailsInprogressBindingSource.ResetCurrentItem();
}
// refreshInProgressEnquiry(CurrentSelectedEnquiryID);
}
}
private void btnAddContactInfo_Click(object sender, EventArgs e)
{
Data.Models.Facilitator CurrentFacilitatorObj = (Data.Models.Facilitator)facilitatorBindingSource.Current;
frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0);
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
Dbconnection.Facilitators.Attach(CurrentFacilitatorObj);
Dbconnection.ContactDetails.Attach(frm.CurrentDetail);
CurrentFacilitatorObj.Individual.ContactDetails.Add(frm.CurrentDetail);
Dbconnection.SaveChanges();
Dbconnection.Entry(frm.CurrentDetail).Reference("LookupContactType").Load();
};
this.refreshFacilitatorContactDetails();
}
}
private void btnAddCompmayContactDetail_Click(object sender, EventArgs e)
{
using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0))
{
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction())
{
try
{
//CRUD Operations
/*
* this steps follow to both entities
*
* 1 - create instance of entity with relative primary key
*
* 2 - add instance to context
*
* 3 - attach instance to context
*/
// 1
Data.Models.Company c = new Data.Models.Company {
CompanyID = CurrentlySelectedCompany.CompanyID
};
// 2
Dbconnection.Companies.Add(c);
// 3
Dbconnection.Companies.Attach(c);
// 1
ContactDetail cd = new ContactDetail {
ContactDetailID = frm.CurrentDetail.ContactDetailID
};
// 2
Dbconnection.ContactDetails.Add(cd);
// 3
Dbconnection.ContactDetails.Attach(cd);
// like previous method add instance to navigation property
c.ContactDetails.Add(cd);
////saves all above operations within one transaction
Dbconnection.SaveChanges();
//commit transaction
dbTran.Commit();
}
catch (Exception ex)
{
if (ex is DbEntityValidationException)
{
foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Rollback transaction if exception occurs
dbTran.Rollback();
}
}
};
using (var Dbconnection = new MCDEntities())
{
Dbconnection.ContactDetails.Attach(frm.CurrentDetail);
Dbconnection.Entry(frm.CurrentDetail).Reference(a => a.LookupContactType).Load();
};
CurrentlySelectedCompany.ContactDetails.Add(frm.CurrentDetail);
refreshCompanyContactDetails();
}
}
}
private void btnAddContactInfo_Click(object sender, EventArgs e)
{
Individual CurrentContact = (Individual)individualBindingSource.Current;
frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0);
frm.ShowDialog();
if (frm.CurrentDetail != null)
{
using (var Dbconnection = new MCDEntities())
{
using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction())
{
try
{
Individual CurrentIndividual = (Individual)individualBindingSource.Current;
//CRUD Operations
/*
* this steps follow to both entities
*
* 1 - create instance of entity with relative primary key
*
* 2 - add instance to context
*
* 3 - attach instance to context
*/
// 1
ContactDetail CD = new ContactDetail()
{
ContactDetailID = frm.CurrentDetail.ContactDetailID
};
// 2
Dbconnection.ContactDetails.Add(CD);
// 3
Dbconnection.ContactDetails.Attach(CD);
// 1
Individual Individ = new Individual {
IndividualID = CurrentIndividual.IndividualID
};
// 2
Dbconnection.Individuals.Add(Individ);
// 3
Dbconnection.Individuals.Attach(Individ);
// like previous method add instance to navigation property
Individ.ContactDetails.Add(CD);
// call SaveChanges
Dbconnection.SaveChanges();
////saves all above operations within one transaction
//commit transaction
dbTran.Commit();
}
catch (Exception ex)
{
if (ex is DbEntityValidationException)
{
foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors)
{
foreach (DbValidationError error in entityErr.ValidationErrors)
{
MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//Rollback transaction if exception occurs
dbTran.Rollback();
}
}
};
this.refreshCompanyContactDetails();
}
}
