public static RolesDM ReadRoleByID(long roleId)
{
try
{
RolesDM _role = new RolesDM();
using (SqlCommand cmd = new SqlCommand("READ_ROLE_BY_ID", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("Role_ID", roleId);
SqlConnect.Connection.Open();
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
_role.RoleId = (Int64)reader["Role_ID"];
_role.RoleName = (string)reader["Role_Name"];
_role.RoleDescription = (string)reader["Role_Description"];
}
}
}
SqlConnect.Connection.Close();
}
return(_role);
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
throw ex;
}
}
public static List <RolesDM> ReadRoles()
{
List <RolesDM> customerList = new List <RolesDM>();
try
{
using (SqlCommand cmd = new SqlCommand("READ_ROLES", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnect.Connection.Open();
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var _role = new RolesDM();
_role.RoleName = (string)reader["Role_Name"];
_role.RoleDescription = (string)reader["Role_Description"];
_role.RoleId = (Int64)reader["Role_ID"];
customerList.Add(_role);
}
}
}
SqlConnect.Connection.Close();
}
return(customerList);
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
throw ex;
}
}
public static void DeleteRole(RolesDM _role)
{
try
{
using (SqlCommand cmd = new SqlCommand("DELETE_ROLE", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Role_ID", _role.RoleId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
//Write to error log
throw ex;
}
}
/// <summary>
/// Basic CRUD methods for Role information. RoleDM is the model being used here.
/// </summary>
#region ROLE DAL METHODS
public static void CreateRole(RolesDM _role)
{
try
{
//Creating a way of adding new user information to my database
using (SqlCommand cmd = new SqlCommand("CREATE_ROLE", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Role_Name", _role.RoleName);
cmd.Parameters.AddWithValue("@Role_Description", _role.RoleDescription);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception e)
{
SqlConnect.Connection.Close();
throw (e);
}
}
public static void UpdateRole(RolesDM _role)
{
try
{
using (SqlCommand cmd = new SqlCommand("UPDATE_ROLE", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Role_Name", _role.RoleName);
cmd.Parameters.AddWithValue("@Role_Number", _role.RoleDescription);
cmd.Parameters.AddWithValue("@Role_ID", _role.RoleId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception e)
{
SqlConnect.Connection.Close();
throw (e);
}
}
public ActionResult ReadRoleByID(RolesDM role)
{
return(View(Mapper.Map <RolesVM>(RolesDAL.ReadRoleByID(role.RoleId))));
}
