public static Result DeleteTinNhanMau(List <string> keys) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew)) { string desc = string.Empty; foreach (string key in keys) { TinNhanMau tnm = db.TinNhanMaus.SingleOrDefault <TinNhanMau>(ss => ss.TinNhanMauGUID.ToString() == key); if (tnm != null) { tnm.DeletedDate = DateTime.Now; tnm.DeletedBy = Guid.Parse(Global.UserGUID); tnm.Status = (byte)Status.Deactived; desc += string.Format("- GUID: '{0}', Tiêu đề: '{1}', Nội dung: '{2}', Duyệt: '{3}'\n", tnm.TinNhanMauGUID.ToString(), tnm.TieuDe, tnm.NoiDung, tnm.IsDuyet); } } //Tracking desc = desc.Substring(0, desc.Length - 1); Tracking tk = new Tracking(); tk.TrackingGUID = Guid.NewGuid(); tk.TrackingDate = DateTime.Now; tk.DocStaffGUID = Guid.Parse(Global.UserGUID); tk.ActionType = (byte)ActionType.Delete; tk.Action = "Xóa tin nhắn mẫu"; tk.Description = desc; tk.TrackingType = (byte)TrackingType.None; tk.ComputerName = Utility.GetDNSHostName(); db.Trackings.InsertOnSubmit(tk); db.SubmitChanges(); t.Complete(); } } catch (System.Data.SqlClient.SqlException se) { result.Error.Code = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT; result.Error.Description = se.ToString(); } catch (Exception e) { result.Error.Code = ErrorCode.UNKNOWN_ERROR; result.Error.Description = e.ToString(); } finally { if (db != null) { db.Dispose(); db = null; } } return(result); }
public static Result InsertTinNhanMau(TinNhanMau tinNhanMau) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); string desc = string.Empty; using (TransactionScope t = new TransactionScope(TransactionScopeOption.RequiresNew)) { //Insert if (tinNhanMau.TinNhanMauGUID == null || tinNhanMau.TinNhanMauGUID == Guid.Empty) { tinNhanMau.TinNhanMauGUID = Guid.NewGuid(); db.TinNhanMaus.InsertOnSubmit(tinNhanMau); db.SubmitChanges(); //Tracking desc += string.Format("- GUID: '{0}', Tiêu đề: '{1}', Nội dung: '{2}', Duyệt: '{3}'", tinNhanMau.TinNhanMauGUID.ToString(), tinNhanMau.TieuDe, tinNhanMau.NoiDung, tinNhanMau.IsDuyet); Tracking tk = new Tracking(); tk.TrackingGUID = Guid.NewGuid(); tk.TrackingDate = DateTime.Now; tk.DocStaffGUID = Guid.Parse(Global.UserGUID); tk.ActionType = (byte)ActionType.Add; tk.Action = "Thêm tin nhắn mẫu"; tk.Description = desc; tk.TrackingType = (byte)TrackingType.None; tk.ComputerName = Utility.GetDNSHostName(); db.Trackings.InsertOnSubmit(tk); db.SubmitChanges(); } else //Update { TinNhanMau tnm = db.TinNhanMaus.SingleOrDefault <TinNhanMau>(s => s.TinNhanMauGUID == tinNhanMau.TinNhanMauGUID); if (tnm != null) { tnm.TieuDe = tinNhanMau.TieuDe; tnm.NoiDung = tinNhanMau.NoiDung; tnm.CreatedDate = tinNhanMau.CreatedDate; tnm.CreatedBy = tinNhanMau.CreatedBy; tnm.UpdatedDate = tinNhanMau.UpdatedDate; tnm.UpdatedBy = tinNhanMau.UpdatedBy; tnm.DeletedDate = tinNhanMau.DeletedDate; tnm.DeletedBy = tinNhanMau.DeletedBy; tnm.Status = tinNhanMau.Status; tnm.IsDuyet = tinNhanMau.IsDuyet; //Tracking desc += string.Format("- GUID: '{0}', Tiêu đề: '{1}', Nội dung: '{2}', Duyệt: '{3}'", tnm.TinNhanMauGUID.ToString(), tnm.TieuDe, tnm.NoiDung, tnm.IsDuyet); Tracking tk = new Tracking(); tk.TrackingGUID = Guid.NewGuid(); tk.TrackingDate = DateTime.Now; tk.DocStaffGUID = Guid.Parse(Global.UserGUID); tk.ActionType = (byte)ActionType.Edit; tk.Action = "Sửa tin nhắn mẫu"; tk.Description = desc; tk.TrackingType = (byte)TrackingType.None; tk.ComputerName = Utility.GetDNSHostName(); db.Trackings.InsertOnSubmit(tk); db.SubmitChanges(); } } t.Complete(); } } catch (System.Data.SqlClient.SqlException se) { result.Error.Code = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT; result.Error.Description = se.ToString(); } catch (Exception e) { result.Error.Code = ErrorCode.UNKNOWN_ERROR; result.Error.Description = e.ToString(); } finally { if (db != null) { db.Dispose(); db = null; } } return(result); }