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);
}
