public SiteMasterDO UpdateSiteMaster(SiteMasterDO smObj) { string site_op = string.Empty; try { using (SqlConnection connection = new SqlConnection(FMEADBConnectionstring)) { using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandText = "FMEA_SP_UpdateSiteMaster"; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandTimeout = FMEADBTimeout; command.Parameters.AddWithValue("@Site_Number", smObj.Site_Number); command.Parameters.AddWithValue("@Site_Abbr", smObj.Site_Abbr); command.Parameters.AddWithValue("@Site_Desc", smObj.Site_Desc); command.Parameters.AddWithValue("@Site_Operational", smObj.Update_Operational ? smObj.Site_Operational : false); command.Parameters.AddWithValue("@Update_Operational", smObj.Update_Operational); connection.Open(); command.ExecuteNonQuery(); } } } catch (SqlException ex) { throw ex; } return(smObj); }
public IEnumerable <SiteMasterDO> GetAll() { List <SiteMasterDO> siteMaster = new List <SiteMasterDO>(); try { using (SqlConnection connection = new SqlConnection(FMEADBConnectionstring)) { using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandText = "FMEA_SP_GetAllSiteMasterRecords"; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandTimeout = FMEADBTimeout; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { SiteMasterDO sMaster = new SiteMasterDO() { Site_Number = reader.IsDBNull(reader.GetOrdinal(FMEAConstants.Site_Number)) ? null : reader.GetString(reader.GetOrdinal(FMEAConstants.Site_Number)), Site_Abbr = reader.IsDBNull(reader.GetOrdinal(FMEAConstants.Site_Abbr)) ? null : reader.GetString(reader.GetOrdinal(FMEAConstants.Site_Abbr)), Site_Desc = reader.IsDBNull(reader.GetOrdinal(FMEAConstants.Site_Desc)) ? null : reader.GetString(reader.GetOrdinal(FMEAConstants.Site_Desc)), Site_Operational = reader.IsDBNull(reader.GetOrdinal(FMEAConstants.Site_Operational)) ? (Boolean?)null : reader.GetBoolean(reader.GetOrdinal(FMEAConstants.Site_Operational)), }; siteMaster.Add(sMaster); } } } } catch (Exception) { throw; } return(siteMaster); }
public async Task <SiteMasterDO> UpdateSiteMasterRecord(SiteMasterDO siteMasterDO) { return(await _httpClient.PutJsonAsync <SiteMasterDO>($"/api/sitemaster/", siteMasterDO)); }
public IActionResult CreateSiteMasterRecord(SiteMasterDO siteMasterDO) { return(Ok(_siteMasterRepository.CreateSiteMaster(siteMasterDO))); }