public void DeleteMeterHistory(t_Meter_Histories history)
{
try
{
meterHistoryRepository.DeleteMeterHistory(history);
}
catch (Exception ex)
{
//
throw ex;
}
}
public void UpdateMeterHistory(t_Meter_Histories meterHistory, t_Meter_Histories orgiMeterHistory)
{
try
{
meterHistoryRepository.UpdateMeterHistory(meterHistory, orgiMeterHistory);
}
catch (Exception ex)
{
//
throw ex;
}
}
public void InsertMeterHistory(t_Meter_Histories meterHistory)
{
try
{
meterHistoryRepository.InsertMeterHistory(meterHistory);
}
catch (Exception ex)
{
//
throw ex;
}
}
private void SetControlValues(t_Meter_Histories meterHistory)
{
var site = _siteBL.GetSite(meterHistory.SiteID);
cboSiteID.Text = site.SiteAliasName;
dtmChange.SelectedDate = meterHistory.DateChanged;
cboOldSerials.SelectedValue = meterHistory.OldMeterSerial;
cboNewSerials.SelectedValue = meterHistory.NewMeterSerial;
nmrOldIndex.Value = meterHistory.OldIndex;
nmrNewIndex.Value = meterHistory.NewIndex;
txtDescription.Text = meterHistory.Description;
}
public void InsertMeterHistory(t_Meter_Histories meterHistory)
{
try
{
context.t_Meter_Histories.Add(meterHistory);
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
private t_Meter_Histories GetControlValues()
{
t_Meter_Histories meterHistory = new t_Meter_Histories();
meterHistory.DateChanged = (DateTime)dtmChange.SelectedDate;
meterHistory.Description = txtDescription.Text;
meterHistory.NewMeterSerial = cboNewSerials.SelectedValue;
meterHistory.OldMeterSerial = cboOldSerials.SelectedValue;
meterHistory.NewIndex = nmrNewIndex.Value;
meterHistory.OldIndex = nmrOldIndex.Value;
meterHistory.SiteID = cboSiteID.SelectedValue;
var oldMeter = _meterBL.GetMeter(meterHistory.OldMeterSerial);
var newMeter = _meterBL.GetMeter(meterHistory.NewMeterSerial);
meterHistory.OldAccreditation = (oldMeter == null ? null : oldMeter.AccreditationDocument);
meterHistory.NewAccreditation = (newMeter == null ? null : newMeter.AccreditationDocument);
return(meterHistory);
}
public void DeleteMeterHistory(t_Meter_Histories history)
{
try
{
var dbHistory = context.t_Meter_Histories.FirstOrDefault(h => h.SiteID == history.SiteID && h.DateChanged == history.DateChanged);
//context.t_Meter_Histories.Attach(history);
//context.t_Meter_Histories.Remove(history);
if (dbHistory != null)
{
context.t_Meter_Histories.Remove(dbHistory);
}
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
public void UpdateMeterHistory(t_Meter_Histories meterHistory, t_Meter_Histories orgiMeterHistory)
{
try
{
context.t_Meter_Histories.Attach(orgiMeterHistory);
orgiMeterHistory.DateChanged = meterHistory.DateChanged;
orgiMeterHistory.Description = meterHistory.Description;
orgiMeterHistory.NewAccreditation = meterHistory.NewAccreditation;
orgiMeterHistory.NewIndex = meterHistory.NewIndex;
orgiMeterHistory.NewMeterSerial = meterHistory.NewMeterSerial;
orgiMeterHistory.OldAccreditation = meterHistory.OldAccreditation;
orgiMeterHistory.OldIndex = meterHistory.OldIndex;
orgiMeterHistory.OldMeterSerial = meterHistory.OldMeterSerial;
orgiMeterHistory.SiteID = meterHistory.SiteID;
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
