/// <summary>
/// Basic CRUD methods for Assignment information. AssignmentDM is the model being used here.
/// </summary>
///
#region ASSIGNMENT DAL Methods
public static void CreateAssignment(AssignmentDM _assignment)
{
try
{
//Creating a way of adding new user information to my database
using (SqlCommand cmd = new SqlCommand("CREATE_ASSIGNMENT", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Assignment_Name", _assignment.AssignmentName);
cmd.Parameters.AddWithValue("@StartDate", _assignment.StartDate.ToShortDateString());
if (_assignment.EndDate != null)
{
cmd.Parameters.AddWithValue("@EndDate", _assignment.EndDate.ToShortDateString());
}
else
{
cmd.Parameters.AddWithValue("@EndDate", null);
}
cmd.Parameters.AddWithValue("@Client_Id", _assignment.ClientId);
cmd.Parameters.AddWithValue("@Position_Id", _assignment.PositionId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception e)
{
SqlConnect.Connection.Close();
throw (e);
}
}
public static void DeleteAssignment(AssignmentDM _assignment)
{
try
{
using (SqlCommand cmd = new SqlCommand("DELETE_ADDRESS", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Assignment_ID", _assignment.AssignmentId);
SqlConnect.Connection.Open();
cmd.ExecuteNonQuery();
SqlConnect.Connection.Close();
}
}
catch (Exception e)
{
SqlConnect.Connection.Close();
throw (e);
}
}
public static List <AssignmentDM> ReadAssignments()
{
List <AssignmentDM> _assignmentList = new List <AssignmentDM>();
try
{
using (SqlCommand cmd = new SqlCommand("READ_ASSIGNMENTS", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnect.Connection.Open();
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var _assignment = new AssignmentDM();
_assignment.AssignmentId = (Int64)reader["Assignment_ID"];
_assignment.AssignmentName = (string)reader["Assignment_Name"];
_assignment.StartDate = (DateTime)reader["Start_Date"];
_assignment.EndDate = (DateTime)reader["End_Date"];
_assignment.ClientId = (Int64)reader["Client_ID"];
_assignment.PositionId = (Int64)reader["Position_ID"];
_assignmentList.Add(_assignment);
}
}
}
SqlConnect.Connection.Close();
}
return(_assignmentList);
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
throw ex;
}
}
public static AssignmentDM ReadAssignmentByID(string assignmentId)
{
AssignmentDM _assignment = new AssignmentDM();
try
{
using (SqlCommand cmd = new SqlCommand("READ_ASSIGNMENT_BY_ID", SqlConnect.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnect.Connection.Open();
cmd.Parameters.AddWithValue("@Assignment_ID", assignmentId);
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
_assignment.AssignmentId = (Int64)reader["Assignment_ID"];
_assignment.AssignmentName = (string)reader["Assignment_Name"];
_assignment.StartDate = (DateTime)reader["Start_Date"];
_assignment.EndDate = (DateTime)reader["End_Date"];
_assignment.ClientId = (Int64)reader["Client_ID"];
_assignment.PositionId = (Int64)reader["Position_ID"];
}
}
}
SqlConnect.Connection.Close();
}
return(_assignment);
}
catch (Exception ex)
{
SqlConnect.Connection.Close();
throw ex;
}
}
public ActionResult ReadAssignmentByID(AssignmentDM assignment)
{
return(View(Mapper.Map <AddressVM>(AssignmentDAL.ReadAssignmentByID(assignment.AssignmentId.ToString()))));
}
