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