public static Change_Request ViewChangeRequest(int changeRequestID) { Change_Request myChangeRequest = new Change_Request(); SqlConnection conn = Connection.GetConnection(); SqlCommand comm = new SqlCommand("SP_View_CR", conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.AddWithValue("@changeRequestID", changeRequestID); try { conn.Open(); SqlDataReader reader = comm.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { myChangeRequest.Title = reader.GetString(0); myChangeRequest.Details = reader.GetString(3); myChangeRequest.Benefits = reader.GetString(4); myChangeRequest.Alternatives = reader.GetString(5); myChangeRequest.Priority = reader.GetString(1); myChangeRequest.Status = reader.GetString(2); myChangeRequest.DueDate = reader.GetString(6); myChangeRequest.ReviewDate = reader.GetString(7); myChangeRequest.FinanceImpact = reader.GetDecimal(8); myChangeRequest.ScheduleImpact = reader.GetString(11); myChangeRequest.ResourceRequired = reader.GetString(10); myChangeRequest.ImpactSummary = reader.GetString(9); myChangeRequest.ChangeType = reader.GetInt32(12); } } catch (System.IO.IOException ex) { throw ex; } finally { conn.Close(); } return(myChangeRequest); }
public static List <Change_Request> GetChangeRequest() { List <Change_Request> myChangeRequest = new List <Change_Request> { }; SqlConnection conn = Connection.GetConnection(); SqlCommand comm = new SqlCommand("SP_HomeView_CR", conn); comm.CommandType = CommandType.StoredProcedure; try { conn.Open(); SqlDataReader reader = comm.ExecuteReader(); Change_Request cr; while (reader.Read()) { cr = new Change_Request(); cr.ChangeRequestID = reader.GetInt32(0); //cr.UserID = reader.GetInt32(1); cr.Title = reader.GetString(2); cr.Priority = reader.GetString(3); cr.Status = reader.GetString(4); myChangeRequest.Add(cr); } reader.Close(); } catch (System.IO.IOException ex) { throw ex; } finally { conn.Close(); } return(myChangeRequest); }
public static int NewChangeRequest(Change_Request myChangeRequest) { int ChangeRequestID; SqlConnection conn = Connection.GetConnection(); SqlCommand comm = new SqlCommand("SP_Create_CR", conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.AddWithValue("@title", myChangeRequest.Title); comm.Parameters.AddWithValue("@priority", myChangeRequest.Priority); comm.Parameters.AddWithValue("@status", myChangeRequest.Status); comm.Parameters.AddWithValue("@details", myChangeRequest.Details); comm.Parameters.AddWithValue("@benefits", myChangeRequest.Benefits); comm.Parameters.AddWithValue("@alternatives", myChangeRequest.Alternatives); comm.Parameters.AddWithValue("@due_by", myChangeRequest.DueDate).ToString(); comm.Parameters.AddWithValue("@review_by", myChangeRequest.ReviewDate).ToString(); comm.Parameters.AddWithValue("@financial_impact", myChangeRequest.FinanceImpact); comm.Parameters.AddWithValue("@impact_summary", myChangeRequest.ImpactSummary); comm.Parameters.AddWithValue("@resources_required", myChangeRequest.ResourceRequired); comm.Parameters.AddWithValue("@schedule_impact", myChangeRequest.ScheduleImpact); comm.Parameters.AddWithValue("@type", myChangeRequest.ChangeType); try { conn.Open(); ChangeRequestID = comm.ExecuteNonQuery(); } catch (System.IO.IOException ex) { throw ex; } finally { conn.Close(); } return(ChangeRequestID); }