public CasualtyModel GetCasualtyById(int casualtyId) { CasualtyModel casualty = new CasualtyModel(); SqlConnection conn = new SqlConnection(_conn); SqlCommand sqlCommand = new SqlCommand("GetCasualtyById", conn); sqlCommand.CommandType = CommandType.StoredProcedure; try { conn.Open(); sqlCommand.Parameters.AddWithValue("@Id", casualtyId); SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { casualty = new CasualtyModel { Id = reader.GetInt32(0), Firstname = reader.GetString(1), Surname = reader.GetString(2), Lastname = reader.GetString(3), BirthDate = reader.GetDateTime(4), Address = reader.GetString(5) }; } } catch (SqlException ex) { _logger.Log(LogLevel.Error, ex.Message); } return(casualty); }
private CasualtyViewModel ParseCasualtyModelToViewModel(CasualtyModel casualty) { CasualtyViewModel casyaltyModel = new CasualtyViewModel { Firstname = casualty.Firstname, Address = casualty.Address, BirthDate = casualty.BirthDate, Lastname = casualty.Lastname, Surname = casualty.Surname }; return(casyaltyModel); }
public void Edit(CasualtyModel casualtyModel) { SqlConnection conn = new SqlConnection(_conn); SqlCommand command = new SqlCommand("UpdateCasualty", conn) { CommandType = CommandType.StoredProcedure }; try { conn.Open(); SqlParameter[] sqlParameters = { new SqlParameter() { ParameterName = "@Id", Value = casualtyModel.Id }, new SqlParameter() { ParameterName = "@Firstname", Value = casualtyModel.Firstname }, new SqlParameter() { ParameterName = "@Surname", Value = casualtyModel.Surname }, new SqlParameter() { ParameterName = "@Lastname", Value = casualtyModel.Lastname }, new SqlParameter() { ParameterName = "@Address", Value = casualtyModel.Address }, new SqlParameter() { ParameterName = "@Birthdate", Value = casualtyModel.BirthDate } }; command.Parameters.AddRange(sqlParameters); command.ExecuteNonQuery(); conn.Close(); } catch (SqlException ex) { _logger.Log(LogLevel.Error, ex.Message); } }
public void Edit(CasualtyModel casualtyModel) { _repos.Edit(casualtyModel); }
public void Create(CasualtyModel casualtyModel) { _repos.Create(casualtyModel); }