public static int NewUser(ApplicationUser objUser) { List <ParameterInfo> parameters = new List <ParameterInfo>(); parameters.Add(new ParameterInfo() { ParameterName = "Id", ParameterValue = objUser.Id }); parameters.Add(new ParameterInfo() { ParameterName = "UserName", ParameterValue = objUser.UserName }); parameters.Add(new ParameterInfo() { ParameterName = "Email", ParameterValue = objUser.Email }); parameters.Add(new ParameterInfo() { ParameterName = "Password", ParameterValue = objUser.Password }); parameters.Add(new ParameterInfo() { ParameterName = "Status", ParameterValue = objUser.Status }); int success = DapperSqlHelper.ExecuteQuery("spNew_Account", parameters); return(success); }
public static int UpdateUser(ApplicationUser objUser) { List <ParameterInfo> parameters = new List <ParameterInfo>(); parameters.Add(new ParameterInfo() { ParameterName = "Email", ParameterValue = objUser.Email }); int success = DapperSqlHelper.ExecuteQuery("UpdateAccount", parameters); return(success); }
public static int DeleteUserRole(string userID, string roleName) { List <ParameterInfo> parameters = new List <ParameterInfo>(); parameters.Add(new ParameterInfo() { ParameterName = "AccountID", ParameterValue = userID }); parameters.Add(new ParameterInfo() { ParameterName = "RoleName", ParameterValue = roleName }); int success = DapperSqlHelper.ExecuteQuery("DeleteAccountRole", parameters); return(success); }