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