public virtual JsonNetResult SaveByEntityFramework(ARCustomer model)
{
var repository = new GenericRepository <ARCustomer>();
try
{
repository.Update(model);
return(JsonNet("Save successfully !"));
}
catch (BusinessException businessException)
{
return(JsonNet(BuildErrorModelBase(CommonResx.SaveFailedMessage, businessException, "ARCustomer")));
}
}
public string CreateUser(FormCollection signupForm, string userType)
{
string check = "";
var userFromDB = db.ADUsers.ToList().Where(p => p.ADUserName == signupForm["username"]).FirstOrDefault();
if (userFromDB != null)
{
check = "fail";
return(check);
}
var user = new ADUser();
var lastUserFromDb = db.ADUsers.ToList().LastOrDefault();
user.ADUserID = lastUserFromDb == null ? 1 : lastUserFromDb.ADUserID + 1;
user.AAStatus = "Alive";
user.AACreatedDate = DateTime.Now;
user.ADUserName = signupForm["username"];
user.ADPassword = Common.GetMD5(signupForm["password"]);
if ("customer".Equals(userType))
{
var customerFromDb = db.ARCustomers.ToList().Where(x => x.ARCustomerContactPhone == signupForm["phone"] || x.ARCustomerContactEmail == signupForm["email"]).FirstOrDefault();
if (customerFromDb != null)
{
check = "fail";
return(check);
}
user.FK_ADUserGroupID = 1; // Todo:
var customer = new ARCustomer();
var lastCustomerFromDb = db.ARCustomers.ToList().LastOrDefault();
customer.ARCustomerID = lastCustomerFromDb == null ? 1 : lastCustomerFromDb.ARCustomerID + 1;
customer.FK_ADUserID = user.ADUserID;
customer.AAStatus = "Alive";
customer.AACreatedDate = DateTime.Now;
customer.ARCustomerName = signupForm["name"];
customer.ARCustomerNo = "KH" + customer.ARCustomerID.ToString();
customer.ARCustomerBirthDay = signupForm["birthDay"] != null?DateTime.Parse(signupForm["birthDay"]) : DateTime.Now;
customer.ARCustomerSex = signupForm["gender"] == "male" ? true : false;
customer.ARCustomerAddress = signupForm["address"];
customer.ARCustomerContactPhone = signupForm["phone"];
customer.ARCustomerContactEmail = signupForm["email"];
db.ADUsers.Add(user);
db.ARCustomers.Add(customer);
db.SaveChanges();
check = "success";
return(check);
}
else
{
var supplierFormDB = db.APSuppliers.ToList().Where(p => p.APSupplierContactPhone == signupForm["phone"].ToString() || p.APSupplierContactEmail == signupForm["email"].ToString()).FirstOrDefault();
if (supplierFormDB != null)
{
check = "fail";
return(check);
}
var objUserGroup = db.ADUserGroups.FirstOrDefault(p => p.ADUserGroupName == "Supplier" && p.AAStatus == "Alive");
user.FK_ADUserGroupID = objUserGroup != null ? objUserGroup.ADUserGroupID : 0;
var supplier = new APSupplier();
var lastSupplierFromDB = db.APSuppliers.ToList().LastOrDefault();
supplier.APSupplierID = lastSupplierFromDB == null ? 1 : lastSupplierFromDB.APSupplierID + 1;
supplier.FK_ADUserID = user.ADUserID;
supplier.AAStatus = "Alive";
supplier.AACreatedDate = DateTime.Now;
supplier.APSupplierName = signupForm["name"];
supplier.APSupplierNo = "NCC" + supplier.APSupplierID.ToString();
supplier.APSupplierAddress = signupForm["address"];
supplier.APSupplierContactPhone = signupForm["phone"];
supplier.APSupplierContactEmail = signupForm["email"];
db.ADUsers.Add(user);
db.APSuppliers.Add(supplier);
db.SaveChanges();
check = "success";
return(check);
}
}
