public bool InsertFromExcel(CMS_MarketingModels model, ref string msg) { var result = true; using (var cxt = new CMS_Context()) { using (var trans = cxt.Database.BeginTransaction()) { try { if (string.IsNullOrEmpty(model.Id)) { var _Id = Guid.NewGuid().ToString(); model.Id = _Id; var e = new CMS_Marketing { Id = _Id, CustomerId = model.CustomerId, CustomerName = model.CustomerName, OperatorName = model.OperatorName, RunTime = model.RunTime.Value, SendFrom = model.SendFrom, SendTo = model.SendTo, SMSContent = model.SMSContent, SMSPrice = model.SMSPrice, SMSType = model.SMSType, Status = model.Status, TimeInput = model.TimeInput, IsActive = model.IsActive, SMSRate = model.SMSRate, UpdatedBy = model.UpdatedBy, UpdatedDate = DateTime.Now, CreatedBy = model.CreatedBy, CreatedDate = DateTime.Now, }; cxt.CMS_Marketing.Add(e); var customer = cxt.CMS_Customers.Where(x => x.Id.Equals(model.CustomerId)).FirstOrDefault(); customer.TotalCredit = customer.TotalCredit - model.SMSPrice; } cxt.SaveChanges(); trans.Commit(); } catch (Exception ex) { msg = "Vui lòng kiểm tra đường truyền"; result = false; trans.Rollback(); } finally { cxt.Dispose(); } } } return(result); }
public bool CreateOrUpdate(CMS_MarketingModels model, ref string msg) { var result = true; using (var cxt = new CMS_Context()) { using (var trans = cxt.Database.BeginTransaction()) { try { if (string.IsNullOrEmpty(model.Id)) { var _Id = Guid.NewGuid().ToString(); var e = new CMS_Marketing { Id = _Id, CustomerId = model.CustomerId, CustomerName = model.CustomerName, OperatorName = model.OperatorName, RunTime = model.RunTime.Value, SendFrom = model.SendFrom, SendTo = model.SendTo, SMSContent = model.SMSContent, SMSPrice = model.SMSPrice, SMSType = model.SMSType, Status = model.Status, SMSRate = model.SMSRate, TimeInput = model.TimeInput, IsActive = model.IsActive, UpdatedBy = model.UpdatedBy, UpdatedDate = DateTime.Now, CreatedBy = model.CreatedBy, CreatedDate = DateTime.Now, }; cxt.CMS_Marketing.Add(e); } else { var e = cxt.CMS_Marketing.Find(model.Id); if (e != null) { e.CustomerId = model.CustomerId; e.CustomerName = model.CustomerName; e.OperatorName = model.OperatorName; e.RunTime = model.RunTime.Value; e.SendFrom = model.SendFrom; e.SendTo = model.SendTo; e.SMSContent = model.SMSContent; e.SMSPrice = model.SMSPrice; e.SMSType = model.SMSType; e.Status = model.Status; e.SMSRate = model.SMSRate; e.TimeInput = model.TimeInput; e.IsActive = model.IsActive; e.UpdatedDate = DateTime.Now; e.UpdatedBy = model.UpdatedBy; } } cxt.SaveChanges(); trans.Commit(); } catch (Exception ex) { msg = "Vui lòng kiểm tra đường truyền"; result = false; trans.Rollback(); } finally { cxt.Dispose(); } } } return(result); }