public JsonResult UpdUser(UserModel user, UserAcctModel userAcct)
{
Result data = null;
try
{
data = new Result();
string spName = "UP_USER_TX_UPD";
string[] spParamName = new string[] {
"@pi_intUserNo", "@pi_intMemberStoreNo", "@pi_strUserID", "@pi_strUserName", "@pi_strTeamName",
"@pi_strPhoneNo", "@pi_intBPLevelGroupNo", "@pi_intBPLevelNo", "@pi_intUseState", "@pi_strEmpYMD",
"@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
user.UserNo, user.MemberStoreNo, user.UserID ?? "", user.UserName, user.TeamName,
DBNull.Value, DBNull.Value, user.BPLevelNo, user.UseState, user.EmpYMD,
DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 770;
data.ErrMsg = "Exception in UpdUser : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
public JsonResult InsUser(UserModel user, UserAcctModel userAcct)
{
Result data = null;
try
{
strLoginID = HttpContext.Session.GetString("loginid");
data = new Result();
string spName = "UP_USER_TX_INS";
string[] spParamName = new string[] {
"@pi_strUserID", "@pi_strUserName", "@pi_intMemberStoreNo", "@pi_strTeamName", "@pi_strPhoneNo",
"@pi_intBPLevelGroupNo", "@pi_intBPLevelNo", "@pi_strAdminID", "@pi_strEmpYMD", "@pi_strBankCode",
"@pi_strAccountNo", "@pi_strAccountHolder", "@po_intRetVal", "@po_strErrMsg"
};
object[] spParamValue = new object[] {
user.UserID, user.UserName, user.MemberStoreNo, user.TeamName, DBNull.Value,
user.BPLevelGroupNo, user.BPLevelNo, strLoginID, user.EmpYMD, userAcct.BankCode,
userAcct.AccountNo, userAcct.AccountHolder, DBNull.Value, DBNull.Value
};
data = dbConn.SqlExecuteSPReturnValue(spName, spParamName, spParamValue);
}
catch (Exception ex)
{
data.RetVal = 790;
data.ErrMsg = "Exception in InsUser : " + ex.Message;
return(Json(data));
}
return(Json(new { data }));
}
