public void SaveDayTypes(List <DayTypeConfig> list) { foreach (var item in list) { var obj = _ctx.DayTypeConfigDbs.Where(a => a.DayOfWeek == item.DayOfWeek).FirstOrDefault(); //Mapper.Map<DayTypeConfig, DayTypeConfigDb>(item, obj); obj.DayType = item.DayType; } _ctx.SaveChanges(); }
public static void SaveSubResult(int phoneNumberId, ResultData re) { using (var ctx = new NovaAlertContext()) { var sr = new SubResult() { DisplayId = re.DisplayId, CreatedDate = DateTime.Now, ParentId = phoneNumberId, PhoneNumberId = re.PhoneNumberId, UnitName = re.UnitName, TaskType = (byte)re.TaskType, Task = (byte)re.Task, Level = (byte)re.Level, Result = (byte)re.Result, TimeReceive = re.TimeReceive, TimeChange = re.TimeChange }; if (re.IntervalReceive.HasValue) { sr.IntervalReceive = (long)re.IntervalReceive.Value.TotalSeconds; } if (re.IntervalChange.HasValue) { sr.IntervalChange = (long)re.IntervalChange.Value.TotalSeconds; } ctx.SubResults.Add(sr); ctx.SaveChanges(); } }
public void SaveContact(Contact ct) { using (var ctx = new NovaAlertContext()) { PhoneNumber ph = null; if (ct.PhoneNumberId == 0) { ph = new PhoneNumber(); ctx.PhoneNumbers.Add(ph); } else { ph = ctx.PhoneNumbers.OfType <PhoneNumber>().Where(p => p.PhoneNumberId == ct.PhoneNumberId).FirstOrDefault(); if (ph == null) { throw new InvalidOperationException("Invalid phone number id."); } } Mapper.Map <Contact, PhoneNumber>(ct, ph); ctx.SaveChanges(); if (OnContactChanged != null) { OnContactChanged(this, new EntityChangedEventArgs(ph.PhoneNumberId)); } } }
public void DeleteCallLog(Guid id) { using (var ctx = new NovaAlertContext()) { var cl = new CallLogDb() { CallLogId = id }; ctx.CallLogDbs.Attach(cl); cl.DeletedDate = DateTime.Now; ctx.SaveChanges(); } }
public void AddLog(byte panelId, int userId, string info) { using (var ctx = new NovaAlertContext()) { var log = new DbLog() { CreatedDate = DateTime.Now, PanelId = panelId, UserId = userId, Info = info }; ctx.DbLogs.Add(log); ctx.SaveChanges(); } }
public void UpdateStatus(int phoneNumberId, eTslStatusType type, eTslStatus status) { using (var ctx = new NovaAlertContext()) { var st = new TslStatusDb() { CreatedDate = DateTime.Now, PhoneNumberId = phoneNumberId, Type = (byte)type, Status = (byte)status }; ctx.TslStatusDbs.Add(st); ctx.SaveChanges(); } }
public void SaveCallLogDetail(CallLogDetail en) { lock (syncRoot) { using (var ctx = new NovaAlertContext()) { var cl = ctx.CallLogDetailDbs.Where(c => c.CallLogDetailId == en.CallLogDetailId).FirstOrDefault(); if (cl == null) { cl = new CallLogDetailDb(); ctx.CallLogDetailDbs.Add(cl); } Mapper.Map <CallLogDetail, CallLogDetailDb>(en, cl); ctx.SaveChanges(); } } }
public static void UpdateTask(UnitPhone unit, long?duration, eTaskType taskType) { Entities.Task task = NovaAlert.Dal.NovaAlertCommon.GetLastestTask(unit.Id, Entities.eTaskType.CTT); using (var ctx = new NovaAlertContext()) { var dt = new GroupUnitTask() { GroupId = 0, //unit.GroupId, TaskType = (byte)taskType, PhoneNumberId = unit.PhoneNumberId, Task = (byte)unit.Task.CurrentTask, Level = (byte)unit.Task.Level, Result = (byte)unit.Task.Result, CreatedDate = DateTime.Now, Duration = duration }; ctx.GroupUnitTasks.Add(dt); ctx.SaveChanges(); } }
public void SaveGroup(ContactGroup cg) { using (var ctx = new NovaAlertContext()) { var g = ctx.GroupDbs.Where(gr => gr.GroupId == cg.Id).FirstOrDefault(); if (g == null) { g = new GroupDb(); ctx.GroupDbs.Add(g); } g.Name = cg.Name; if (cg.IsDeleted) { g.DeletedDate = DateTime.Now; } else { foreach (var item in cg.Contacts) { var gu = g.GroupUnits.Where(u => u.PhoneNumberId == item.Contact.PhoneNumberId).FirstOrDefault(); if (gu == null) { gu = new GroupUnitDb(); g.GroupUnits.Add(gu); } gu.PhoneNumberId = item.Contact.PhoneNumberId; gu.ListOrder = item.ListOrder; gu.IsDeleted = item.IsDeleted; } } ctx.SaveChanges(); //if(cg.Id == 0) cg.Id = g.GroupId; if (OnGroupChanged != null) { OnGroupChanged(this, new EntityChangedEventArgs(cg.Id)); } } }
public static void SaveDisplayData(List <DisplayData> list) { using (var ctx = new NovaAlertContext()) { foreach (var item in list) { var dbItem = ctx.DisplayDataDbs.Where(d => d.DisplayId == item.DisplayId).FirstOrDefault(); if (dbItem != null) { if (dbItem.PhoneNumber_1 != item.PhoneNumber_1) { dbItem.PhoneNumber_1 = item.PhoneNumber_1; } if (dbItem.PhoneNumber_2 != item.PhoneNumber_2) { dbItem.PhoneNumber_2 = item.PhoneNumber_2; } } } ctx.SaveChanges(); } }
public void SaveChannels(List <Channel> list) { using (var ctx = new NovaAlertContext()) { foreach (var c in list) { //ctx.ChannelDbs.ToList(); var obj = ctx.ChannelDbs.Where(ch => ch.ChannelId == c.ChannelId).FirstOrDefault(); obj.HostPhoneNumber.Number = c.Number; obj.HostPhoneNumber.AreaCode = c.AreaCode; obj.HostPhoneNumber.IsRestricted = c.IsRestricted; obj.AlertEnabled = c.AlertEnabled; obj.MultiDestEnabled = c.MultiDestEnabled; obj.CCPKEnabled = c.CCPKEnabled; obj.AutoRecording = c.AutoRecording; obj.HotUnitId = c.HotUnitId; //obj.TSLEnabled = c.TSLEnabled; //obj.HostPhoneNumber.TypeCde = c.TypeCde; } ctx.SaveChanges(); } }
public void DeleteContact(int id) { using (var ctx = new NovaAlertContext()) { var ct = ctx.PhoneNumbers.OfType <PhoneNumber>().Where(c => c.PhoneNumberId == id).FirstOrDefault(); if (ct == null) { return; } ct.DeletedDate = DateTime.Now; var groupUnits = ctx.GroupUnitDbs.Where(g => g.PhoneNumberId == id); foreach (var item in groupUnits) { item.IsDeleted = true; } ctx.SaveChanges(); if (OnContactChanged != null) { OnContactChanged(this, new EntityChangedEventArgs(ct.PhoneNumberId)); } } }