public bool CreateOrUpdate(CMS_SimsModels 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_Sims { Id = _Id, OperatorName = model.OperatorName, SimName = model.SimName, SimNumber = model.SimNumber, Status = model.Status, IsActive = model.IsActive, UpdatedBy = model.UpdatedBy, UpdatedDate = DateTime.Now, CreatedBy = model.CreatedBy, CreatedDate = DateTime.Now }; cxt.CMS_Sims.Add(e); } else { var e = cxt.CMS_Sims.Find(model.Id); if (e != null) { e.OperatorName = model.OperatorName; e.SimName = model.SimName; e.SimNumber = model.SimNumber; e.Status = model.Status; 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); }
public bool UpdateStatusSim(string simName, int status, string operatorName) { var result = true; using (var cxt = new CMS_Context()) { using (var trans = cxt.Database.BeginTransaction()) { try { bool isCreateNew = true; var e = cxt.CMS_Sims.Where(x => x.SimName.Equals(simName)).FirstOrDefault(); if (e != null) { if (!string.IsNullOrEmpty(e.Id)) { isCreateNew = false; } } if (isCreateNew) { var _Id = Guid.NewGuid().ToString(); var modelCreate = new CMS_Sims { Id = _Id, OperatorName = operatorName, SimName = simName, SimNumber = "", Status = status, IsActive = true, UpdatedBy = "centri", UpdatedDate = DateTime.Now, CreatedBy = "centri", CreatedDate = DateTime.Now }; cxt.CMS_Sims.Add(modelCreate); } else { if (e != null) { e.OperatorName = operatorName; e.SimName = simName; e.Status = status; e.UpdatedDate = DateTime.Now; e.UpdatedBy = "centri"; } } cxt.SaveChanges(); trans.Commit(); NSLog.Logger.Info(string.Format("Update Status Sim ({0}-{1}): Success", simName, status)); } catch (Exception ex) { NSLog.Logger.Error("Update Status Sim: ", ex); result = false; trans.Rollback(); } finally { cxt.Dispose(); } } } return(result); }