public static void DeleteSprint(SprintDM _sprint) { try { using (SqlCommand cmd = new SqlCommand("DELETE_SPRINT", SqlConnect.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Sprint_ID", _sprint.SprintId); SqlConnect.Connection.Open(); cmd.ExecuteNonQuery(); SqlConnect.Connection.Close(); } } catch (Exception ex) { SqlConnect.Connection.Close(); //Write to error log throw ex; } }
public static List <SprintDM> ReadSprints() { List <SprintDM> sprintList = new List <SprintDM>(); try { using (SqlCommand cmd = new SqlCommand("READ_SPRINTS", SqlConnect.Connection)) { cmd.CommandType = CommandType.StoredProcedure; SqlConnect.Connection.Open(); using (var reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { var _sprint = new SprintDM(); _sprint.SprintId = (Int64)reader["Sprint_ID"]; _sprint.SprintName = (string)reader["Sprint_Name"]; _sprint.SprintNumber = (int)reader["Sprint_Number"]; _sprint.StartDate = (DateTime)reader["Start_Date"]; _sprint.EndDate = (DateTime)reader["End_Date"]; _sprint.ClientId = (Int64)reader["Client_ID"]; _sprint.SprintId = (Int64)reader["Sprint_ID"]; sprintList.Add(_sprint); } } } SqlConnect.Connection.Close(); } return(sprintList); } catch (Exception ex) { SqlConnect.Connection.Close(); throw ex; } }
public static SprintDM ReadSprintById(string sprintId) { SprintDM _sprint = new SprintDM(); try { using (SqlCommand cmd = new SqlCommand("READ_SPRINT_BY_ID", SqlConnect.Connection)) { cmd.CommandType = CommandType.StoredProcedure; SqlConnect.Connection.Open(); cmd.Parameters.AddWithValue("@Sprint_ID", sprintId); using (var reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { _sprint.SprintId = (Int64)reader["Sprint_ID"]; _sprint.SprintName = (string)reader["Sprint_Name"]; _sprint.SprintNumber = (int)reader["Sprint_Number"]; _sprint.StartDate = (DateTime)reader["Start_Date"]; _sprint.EndDate = (DateTime)reader["End_Date"]; _sprint.ClientId = (Int64)reader["Client_ID"]; _sprint.SprintId = (Int64)reader["Sprint_ID"]; } } } SqlConnect.Connection.Close(); } return(_sprint); } catch (Exception ex) { SqlConnect.Connection.Close(); throw ex; } }
/// <summary> /// Basic CRUD methods for Sprint information. SprintDM is the model being used here. /// </summary> #region Sprint DAL METHODS public static void CreateSprint(SprintDM _sprint) { try { //Creating a way of adding new user information to my database using (SqlCommand cmd = new SqlCommand("CREATE_SPRINT", SqlConnect.Connection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Sprint_Number", _sprint.SprintNumber); cmd.Parameters.AddWithValue("@Sprint_Name", _sprint.SprintName); cmd.Parameters.AddWithValue("@Client_ID", _sprint.ClientId); cmd.Parameters.AddWithValue("@Start_Date", _sprint.EndDate.ToShortDateString()); cmd.Parameters.AddWithValue("@End_Date", _sprint.StartDate.ToShortDateString()); SqlConnect.Connection.Open(); cmd.ExecuteNonQuery(); SqlConnect.Connection.Close(); } } catch (Exception e) { SqlConnect.Connection.Close(); throw (e); } }
public ActionResult ReadSprintByID(SprintDM sprint) { return(View(Mapper.Map <SprintVM>(SprintDAL.ReadSprintById(sprint.SprintId.ToString())))); }