public bool DeleteUserRole(UsesRoleDelete userRole)
{
Logging.LogDebugMessage("Method: UserRoleDelete, MethodType: Get, Layer: UserController, Parameters: userRole = " + JsonConvert.SerializeObject(userRole));
using (UserBL deleteUserRole = new UserBL())
{
return(deleteUserRole.DeleteUserRole(userRole));
}
}
/// <summary>Delete the user and roles.</summary>
/// <param name="userRoleDelete"> UsesRoleDelete Object.</param>
/// <returns>List of Users and roles List.</returns>
public bool DeleteUserRole(UsesRoleDelete userRole)
{
Logging.LogDebugMessage("Method: DeleteUserRole, MethodType: Get, Layer: UserDAL, Parameters: userRole = " + JsonConvert.SerializeObject(userRole));
var dataset = new DataSet();
// var retList = new List<Users>();
Boolean checkdeleteValue = false;
try
{
using (var command = new SqlCommand())
{
command.Connection = new SqlConnection(this.ConnectionString);
command.CommandText = "USP_UserRoleDelete";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@RoleID", Value = userRole.RoleID
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserID", Value = userRole.UserID
});
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
adapter.Fill(dataset);
if (dataset != null && dataset.Tables.Count > 0)
{
checkdeleteValue = true;
//retList = EntityCollectionHelper.ConvertTo<Users>(ds.Tables[0]).ToList();
}
else
{
checkdeleteValue = false;
}
}
}
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: DeleteUserRole, Layer: UserDAL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: DeleteUserRole, Layer: UserDAL, Stack Trace: " + ex.ToString());
throw;
}
return(checkdeleteValue);
}
/// <summary>Delete the user and roles.</summary>
/// <param name="userRoleDelete"> UsesRoleDelete Object.</param>
/// <returns>List of Users and roles List.</returns>
public bool DeleteUserRole(UsesRoleDelete userRole)
{
Logging.LogDebugMessage("Method: DeleteUserRole, MethodType: Get, Layer: UserBL, Parameters: userRole = " + JsonConvert.SerializeObject(userRole));
using (UserDAL deleteUserrole = new UserDAL())
{
try
{
return(deleteUserrole.DeleteUserRole(userRole));
}
catch (SqlException sqlEx)
{
Logging.LogErrorMessage("Method: DeleteUserRole, Layer: UserBL, Stack Trace: " + sqlEx.ToString());
throw;
}
catch (Exception ex)
{
Logging.LogErrorMessage("Method: DeleteUserRole, Layer: UserBL, Stack Trace: " + ex.ToString());
throw;
}
}
}
