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; } }