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)));
}
