/// <summary> /// Save new Period /// </summary> /// <param name="str"></param> /// <returns></returns> public Phase AddPeriod(Phase phase) { var conn = new SqlConnection("Data Source=localhost\\SQLENTERPRISE;Initial Catalog=Planner;Integrated Security=SSPI;MultipleActiveResultSets=true"); var newId = 0; try { using (conn) { conn.Open(); var cmd = new SqlCommand("sp_insert_period", conn); cmd.Parameters.Add("@Title", System.Data.SqlDbType.VarChar).Value = phase.Title; cmd.Parameters.Add("@StartDate", System.Data.SqlDbType.DateTime).Value = phase.StartDate; cmd.Parameters.Add("@EndDate", System.Data.SqlDbType.DateTime).Value = phase.EndDate; cmd.Parameters.Add("@Description", System.Data.SqlDbType.VarChar).Value = ""; var returnParameter = new SqlParameter("@NewId", SqlDbType.Int); returnParameter.Direction = ParameterDirection.Output; cmd.Parameters.Add(returnParameter); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.ExecuteNonQuery(); newId = (int)returnParameter.Value; } return new Phase { Title = phase.Title, EndDate = phase.EndDate, StartDate = phase.StartDate, Id = newId }; } catch (Exception ex) { throw; } }
/// <summary> /// Update phase info /// </summary> /// <param name="str"></param> /// <returns></returns> public Phase UpdatePhase(Phase evt) { var conn = new SqlConnection("Data Source=localhost\\SQLENTERPRISE;Initial Catalog=Planner;Integrated Security=SSPI;MultipleActiveResultSets=true"); try { using (conn) { conn.Open(); var cmd = new SqlCommand("sp_update_phase", conn); cmd.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = evt.Id; cmd.Parameters.Add("@StartDate", System.Data.SqlDbType.DateTime).Value = evt.StartDate; cmd.Parameters.Add("@EndDate", System.Data.SqlDbType.DateTime).Value = evt.EndDate; cmd.Parameters.Add("@Title", System.Data.SqlDbType.VarChar).Value = evt.Title; cmd.Parameters.Add("@Description", System.Data.SqlDbType.VarChar).Value = evt.Description ?? ""; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.ExecuteNonQuery(); var rep = new ReleaseRepository(); var phase = rep.GetRelease(evt.Id); return phase; } } catch (Exception ex) { throw; } }