private void SetControlValues(t_Accreditations accreditation)
{
cboAccreditationDocuments.Text = accreditation.AccreditationDocument;
cboAccreditationTypes.SelectedValue = accreditation.AccreditationType;
cboMeter.SelectedValue = accreditation.MeterSerial;
cboTransmitter.SelectedValue = accreditation.TransmitterSerial;
dtmAccredited.SelectedDate = accreditation.AccreditationDate;
dtmExpiry.SelectedDate = accreditation.ExpiryDate;
}
public void DeleteAccreditation(t_Accreditations accreditation)
{
try
{
accreditationRepository.DeleteAccreditation(accreditation);
}
catch (Exception ex)
{
//
throw ex;
}
}
public void UpdateAccreditation(t_Accreditations accreditation, t_Accreditations orgiAccreditation)
{
try
{
accreditationRepository.UpdateAccreditation(accreditation, orgiAccreditation);
}
catch (Exception ex)
{
//
throw ex;
}
}
private t_Accreditations GetControlValues()
{
t_Accreditations accreditation = new t_Accreditations();
accreditation.AccreditationDate = (DateTime)dtmAccredited.SelectedDate;
accreditation.AccreditationDocument = cboAccreditationDocuments.Text;
accreditation.AccreditationType = cboAccreditationTypes.SelectedValue;
accreditation.Description = txtDescription.Text;
accreditation.ExpiryDate = dtmExpiry.SelectedDate;
accreditation.MeterSerial = string.IsNullOrEmpty(cboMeter.Text) ? null : cboMeter.Text;
accreditation.TransmitterSerial = string.IsNullOrEmpty(cboTransmitter.Text) ? null : cboTransmitter.Text;
return(accreditation);
}
public void InsertAccreditation(t_Accreditations accreditation)
{
try
{
context.t_Accreditations.Add(accreditation);
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
public void DeleteAccreditation(t_Accreditations accreditation)
{
try
{
var dbAcc = context.t_Accreditations.SingleOrDefault(a => a.AccreditationDocument == accreditation.AccreditationDocument);
//context.t_Accreditations.Attach(accreditation);
context.t_Accreditations.Remove(dbAcc);
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
public void UpdateAccreditation(t_Accreditations accreditation, t_Accreditations orgiAccreditation)
{
try
{
context.t_Accreditations.Attach(orgiAccreditation);
orgiAccreditation.AccreditationDate = accreditation.AccreditationDate;
orgiAccreditation.AccreditationDocument = accreditation.AccreditationDocument;
orgiAccreditation.AccreditationType = accreditation.AccreditationType;
orgiAccreditation.ExpiryDate = accreditation.ExpiryDate;
orgiAccreditation.MeterSerial = accreditation.MeterSerial;
orgiAccreditation.TransmitterSerial = accreditation.TransmitterSerial;
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
