public RecyclingBank Create(RecyclingBank entity) { using (SqlConnection connection = new SqlConnection(Connection.String)) { SqlCommand command = connection.CreateCommand(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "RecyclingBankCreate"; command.Parameters.Add(new SqlParameter("@plastic", entity.Plastic)); command.Parameters.Add(new SqlParameter("@paper", entity.Paper)); command.Parameters.Add(new SqlParameter("@whiteGlass", entity.WhiteGlass)); command.Parameters.Add(new SqlParameter("@colouredGlass", entity.ColouredGlass)); command.Parameters.Add(new SqlParameter("@metal", entity.Metal)); command.Parameters.Add(new SqlParameter("@capacity", entity.Capacity)); command.Parameters.Add(new SqlParameter("@position", entity.Position)); command.Parameters.Add(new SqlParameter("@creator", entity.Creator)); connection.Open(); int result = (int)command.ExecuteScalar(); if (result < 1) { throw new Exception("Error in CreateRecyclingBank stored procedure."); } entity.Id = (int)result; return(entity); } }
private RecyclingBank MapEntity(SqlDataReader data) { RecyclingBank result = new RecyclingBank(); result.Id = int.Parse(data["Id"].ToString()); result.Plastic = bool.Parse(data["Plastic"].ToString()); result.Paper = bool.Parse(data["Paper"].ToString()); result.WhiteGlass = bool.Parse(data["WhiteGlass"].ToString()); result.ColouredGlass = bool.Parse(data["ColouredGlass"].ToString()); result.Metal = bool.Parse(data["Metal"].ToString()); result.Capacity = int.Parse(data["Capacity"].ToString()); result.Position = data["Position"].ToString(); result.Creator = data["Creator"].ToString(); result.CreateDate = DateTime.Parse(data["CreateDate"].ToString()); return(result); }
public ResponseMessage <RecyclingBank> Create(RecyclingBankCreateRequest data, string uniq) { ResponseMessage <RecyclingBank> response = new ResponseMessage <RecyclingBank>(); try { RecyclingBank user = new RecyclingBank(data, uniq.Reverse()); response.ResponseObject = _recyclingBankRepository.Create(user); response.IsSuccess = true; response.ErrorMessage = "Success"; } catch (Exception ex) { response.IsSuccess = false; response.ErrorMessage = ex.Message; } return(response); }