public bool InsertOrUpdate(CustomerModels model, ref string ActiveCode, ref string msg, ref string key)
{
var result = true;
using (var cxt = new CMS_Context())
{
using (var trans = cxt.Database.BeginTransaction())
{
try
{
var CheckEmail = cxt.CMS_Customers.Any(x => x.Email == model.Email && x.IsActive);
if (CheckEmail)
{
msg = "E-mail is exits system";
key = "Email";
return(false);
}
var CheckPhone = cxt.CMS_Customers.Any(x => x.Phone == model.Phone && x.IsActive);
if (CheckPhone)
{
msg = "Phone is exits system";
key = "Phone";
return(false);
}
if (string.IsNullOrEmpty(model.ID))
{
ActiveCode = CommonHelper.RandomVerifiCode();
var e = new CMS_Customers
{
Id = Guid.NewGuid().ToString(),
CreatedBy = model.CreatedBy,
CreatedDate = DateTime.Now,
Email = model.Email,
FirstName = model.FirstName,
IsActive = model.IsActive,
LastName = model.LastName,
Password = model.Password,
Password2 = model.Password2,
Phone = model.Phone,
UpdatedBy = model.UpdatedBy,
UpdatedDate = DateTime.Now,
Status = model.Status,
MemberID = CommonHelper.RandomCustomerNo()
};
e.CustomerActiveCode.Add(new CMS_CustomerActiveCode
{
Id = Guid.NewGuid().ToString(),
CustomerId = e.Id,
Code = ActiveCode,
IsActive = true,
CreatedDate = DateTime.Now,
UpdatedDate = DateTime.Now
});
cxt.CMS_Customers.Add(e);
}
else
{
var e = cxt.CMS_Customers.Find(model.ID);
if (e != null)
{
e.UpdatedBy = model.UpdatedBy;
e.FirstName = model.FirstName;
e.Email = model.Email;
e.IsActive = model.IsActive;
e.LastName = model.LastName;
e.Password = model.Password;
e.Phone = model.Phone;
e.Status = model.Status;
}
}
cxt.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
result = false;
ActiveCode = "";
trans.Rollback();
msg = "Lỗi đường truyền mạng";
}
finally
{
cxt.Dispose();
}
}
}
return(result);
}
public bool InsertOrUpdate(CustomerModels 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 e = new CMS_Customers
{
Id = Guid.NewGuid().ToString(),
Address = model.Address,
BirthDate = model.BirthDate,
City = model.City,
CompanyName = model.CompanyName,
Country = model.Country,
CreatedBy = model.CreatedBy,
CreatedDate = DateTime.Now,
Description = model.Description,
Email = model.Email,
FirstName = model.FirstName,
Gender = model.Gender,
ImageURL = model.ImageURL,
IsActive = model.IsActive,
LastName = model.LastName,
MaritalStatus = model.MaritalStatus,
Password = model.Password,
Phone = model.Phone,
Street = model.Street,
UpdatedBy = model.UpdatedBy,
UpdatedDate = DateTime.Now
};
cxt.CMS_Customers.Add(e);
}
else
{
var e = cxt.CMS_Customers.Find(model.ID);
if (e != null)
{
e.Address = model.Address;
e.BirthDate = model.BirthDate;
e.City = model.City;
e.CompanyName = model.CompanyName;
e.Country = model.Country;
e.UpdatedBy = model.UpdatedBy;
e.FirstName = model.FirstName;
e.Description = model.Description;
e.Email = model.Email;
e.Gender = model.Gender;
e.ImageURL = model.ImageURL;
e.IsActive = model.IsActive;
e.LastName = model.LastName;
e.MaritalStatus = model.MaritalStatus;
e.Password = model.Password;
e.Phone = model.Phone;
e.Street = model.Street;
}
}
cxt.SaveChanges();
trans.Commit();
}
catch (Exception ex) {
result = false;
trans.Rollback();
msg = "Lỗi đường truyền mạng";
}
finally
{
cxt.Dispose();
}
}
}
return(result);
}
public bool InsertOrUpdateByAdminSite(CustomerModels model, ref string msg)
{
var result = true;
using (var cxt = new CMS_Context())
{
using (var trans = cxt.Database.BeginTransaction())
{
try
{
var CheckEmail = cxt.CMS_Customers.Any(x => x.Email == model.Email && x.Id != model.ID && x.IsActive);
if (CheckEmail)
{
msg = "E-mail is exits system";
return(false);
}
var CheckPhone = cxt.CMS_Customers.Any(x => x.Phone == model.Phone && x.Id != model.ID && x.IsActive);
if (CheckPhone)
{
msg = "Phone is exits system";
return(false);
}
if (string.IsNullOrEmpty(model.ID))
{
var e = new CMS_Customers
{
Id = Guid.NewGuid().ToString(),
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
Password = model.Password,
Password2 = model.Password2,
Phone = model.Phone,
Status = model.Status,
APIKey = model.APIKey,
APIPass = model.APIKey,
IsVerifiedEmail = model.IsVerifiedEmail,
IsVerifiedPhone = model.IsVerifiedPhone,
SMSBalances = model.SMSBalances,
TotalCredit = model.TotalCredit,
IsActive = model.IsActive,
UpdatedBy = model.UpdatedBy,
UpdatedDate = DateTime.Now,
CreatedBy = model.CreatedBy,
CreatedDate = DateTime.Now,
MemberID = CommonHelper.RandomCustomerNo()
};
cxt.CMS_Customers.Add(e);
}
else
{
var e = cxt.CMS_Customers.Find(model.ID);
if (e != null)
{
e.UpdatedBy = model.UpdatedBy;
e.FirstName = model.FirstName;
e.Email = model.Email;
e.IsActive = model.IsActive;
e.LastName = model.LastName;
e.Password = model.Password;
e.Phone = model.Phone;
e.Status = model.Status;
e.APIKey = model.APIKey;
e.APIPass = model.APIKey;
e.IsVerifiedEmail = model.IsVerifiedEmail;
e.IsVerifiedPhone = model.IsVerifiedPhone;
e.SMSBalances = model.SMSBalances;
e.TotalCredit = model.TotalCredit;
}
}
cxt.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
result = false;
trans.Rollback();
msg = "Lỗi đường truyền mạng";
}
finally
{
cxt.Dispose();
}
}
}
return(result);
}
