public ActionResult Create(AccountModel accountModel)
{
try
{
var accountDBModel = new AccountDBModel();
TB_ACCOUNT account = new TB_ACCOUNT();
account.S_ACCOUNT = accountModel.account;
account.S_PASSWORD = accountModel.password;
account.S_FULLNAME = accountModel.fullName;
account.S_PHONE = accountModel.phone;
account.S_ADDRESS = accountModel.address;
account.S_TECHNICAL = accountModel.technical;
account.D_BIRTHDAY = accountModel.birthDay;
account.S_TYPE = accountModel.type == 0 ? "employee" : "manager";
account.N_STORE_ID = accountModel.storeId;
account.N_DEPARTMENT_ID = accountModel.departmentId;
accountDBModel.createAccount(account);
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public TB_ACCOUNT getAccountById(int id)
{
object[] sqlParams =
{
new SqlParameter("@N_ID", id)
};
TB_ACCOUNT result = context.Database.SqlQuery <TB_ACCOUNT>("Usp_GetAccountById @N_ID", sqlParams).SingleOrDefault();
return(result);
}
public TB_ACCOUNT getAccount(string account, string password)
{
object[] sqlParams =
{
new SqlParameter("@S_ACCOUNT", account),
new SqlParameter("@S_PASSWORD", password)
};
TB_ACCOUNT accountResult = context.Database.SqlQuery <TB_ACCOUNT>("Usp_GetAccountLogin @S_ACCOUNT,@S_PASSWORD", sqlParams).SingleOrDefault();
return(accountResult);
}
public object updateAccountById(TB_ACCOUNT model)
{
object[] sqlParams =
{
new SqlParameter("@N_ID", model.N_ID),
new SqlParameter("@S_FULLNAME", model.S_FULLNAME),
new SqlParameter("@S_PHONE", model.S_PHONE),
new SqlParameter("@S_ADDRESS", model.S_ADDRESS),
new SqlParameter("@S_TECHNICAL", model.S_TECHNICAL),
new SqlParameter("@S_PASSWORD", model.S_PASSWORD)
};
var result = context.Database.SqlQuery <object>("Usp_updateAccountById @N_ID,@S_FULLNAME,@S_PHONE,@S_ADDRESS,@S_TECHNICAL,@S_PASSWORD", sqlParams).SingleOrDefault();
return(result);
}
public object createAccount(TB_ACCOUNT account)
{
object[] sqlParams =
{
new SqlParameter("@S_ACCOUNT", account.S_ACCOUNT),
new SqlParameter("@S_PASSWORD", account.S_PASSWORD),
new SqlParameter("@S_TYPE", account.S_TYPE),
new SqlParameter("@S_FULLNAME", account.S_FULLNAME),
new SqlParameter("@S_PHONE", account.S_PHONE),
new SqlParameter("@S_ADDRESS", account.S_ADDRESS),
new SqlParameter("@S_TECHNICAL", account.S_TECHNICAL),
new SqlParameter("@D_BIRTHDAY", account.D_BIRTHDAY),
new SqlParameter("@N_STORE_ID", account.N_STORE_ID),
new SqlParameter("@N_DEPARTMENT_ID", account.N_DEPARTMENT_ID)
};
var result = context.Database.SqlQuery <object>("Usp_InsertAccount @S_ACCOUNT,@S_PASSWORD,@S_TYPE,@S_FULLNAME,@S_PHONE,@S_ADDRESS,@S_TECHNICAL,@D_BIRTHDAY,@N_STORE_ID,@N_DEPARTMENT_ID", sqlParams).SingleOrDefault();
return(result);
}
public ActionResult Edit(AccountModel accountModel)
{
try
{
var model = new AccountDBModel();
TB_ACCOUNT account = new TB_ACCOUNT();
account.N_ID = accountModel.id;
account.S_FULLNAME = accountModel.fullName;
account.S_PHONE = accountModel.phone;
account.S_ADDRESS = accountModel.address;
account.S_TECHNICAL = accountModel.technical;
account.S_PASSWORD = accountModel.password;
model.updateAccountById(account);
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
