public TipCdotData GetCdotData(int projectVersionId) { TipCdotData cdotData = null; SqlCommand cmd = new SqlCommand("[dbo].[GetCDOTData]"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ProjectVersionId", projectVersionId); cdotData = new TipCdotData(); DataTable dt = this.ExecuteDataTable(cmd); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; cdotData.Region = row["Region"] != DBNull.Value ? (short)row["Region"] : (short)0; cdotData.CommDistrict = row["CommDistrict"] != DBNull.Value ? (short)row["CommDistrict"] : (short)0; cdotData.RouteSegment = row["RouteSegment"].ToString(); cdotData.BeginMilePost = row["BeginMilePost"] != DBNull.Value ? (double)row["BeginMilePost"] : 0.0; cdotData.EndMilePost = row["EndMilePost"] != DBNull.Value ? (double)row["EndMilePost"] : 0.0; cdotData.STIPID = row["STIPID"].ToString(); cdotData.STIPProjectDivision = row["STIPProjectDivision"].ToString(); cdotData.CDOTProjectManager = row["CDOTProjectManager"] != DBNull.Value ? (int)row["CDOTProjectManager"] : 0; cdotData.TPRAbbr = row["TPRAbbr"].ToString(); cdotData.TPRID = row["TPRID"] != DBNull.Value ? (short)row["TPRID"] : (short)0; cdotData.LRPNumber = row["LRPNumber"] != DBNull.Value ? (int)row["LRPNumber"] : 0; cdotData.InvestmentCategory = row["InvestmentCategory"].ToString(); cdotData.CorridorID = row["CorridorID"].ToString(); cdotData.CDOTProjectNumber = row["CDOTProjectNumber"].ToString(); cdotData.SubAccount = row["SubAccount"] != DBNull.Value ? (int)row["SubAccount"] : 0; cdotData.ConstructionRE = row["ConstructionRE"] != DBNull.Value ? (int)row["ConstructionRE"] : 0; cdotData.CMSNumber = row["CMSNumber"].ToString(); cdotData.ScheduledADDate = row["ScheduledADDate"] != DBNull.Value ? (DateTime)row["ScheduledADDate"] : DateTime.MinValue; cdotData.ProjectStage = row["ProjectStage"] != DBNull.Value ? (int)row["ProjectStage"] : 0; cdotData.ProjectStageDate = row["ProjectStageDate"] != DBNull.Value ? (DateTime)row["ProjectStageDate"] : DateTime.MinValue; cdotData.ConstructionDate = row["ConstructionDate"] != DBNull.Value ? (DateTime)row["ConstructionDate"] : DateTime.MinValue; cdotData.ProjectClosed = row["ProjectClosed"] != DBNull.Value ? (DateTime)row["ProjectClosed"] : DateTime.MinValue; cdotData.Notes = row["Notes"].ToString(); } return cdotData; }
/// <summary> /// Update ProjectVersion CDOT Data /// </summary> /// <param name="model"></param> public void UpdateCdotData(TipCdotData model, int projectVersionId) { using (SqlCommand command = new SqlCommand("[dbo].[UpdateCdotData]") { CommandType = CommandType.StoredProcedure }) { //model.Adoption != null ? (object)model.Adoption.Value : (object)DBNull.Value command.Parameters.AddWithValue("@ProjectVersionId", projectVersionId); command.Parameters.AddWithValue("@StipId", model.STIPID); this.ExecuteNonQuery(command); } }