public Receipt CreateReceipt(SqlDataReader reader) { var receipt = new Receipt(); receipt.ReceiptId = Convert.ToInt32(reader["ReceiptId"]); receipt.UserId = Convert.ToInt32(reader["UserId"]); receipt.ReceiptName = reader["ReceiptName"].ToString(); receipt.TotalPrice = Convert.ToDecimal(reader["TotalPrice"]); receipt.ReceiptRows = new List<ReceiptRow>(); receipt.ReceiptDate = Convert.ToDateTime(reader["ReceiptDate"]); return receipt; }
public void Insert(Receipt receipt) { if (receipt != null) { try { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var command = new SqlCommand("INSERT INTO [dbo].[Receipt] ([UserId],[ReceiptName],[TotalPrice],[ReceiptDate]) VALUES(@userId,@receiptName,@totalPrice,@receiptDate)", connection); command.Parameters.Add("userId", SqlDbType.Int).Value = receipt.UserId; command.Parameters.Add("@receiptName", SqlDbType.VarChar).Value = receipt.ReceiptName; command.Parameters.Add("@totalPrice", SqlDbType.Decimal).Value = receipt.TotalPrice; command.Parameters.Add("@receiptDate", SqlDbType.Date).Value = receipt.ReceiptDate.Date; var affectedRows = command.ExecuteNonQuery(); } } catch (Exception ex) { CustomLogger.Log(ex); } } }
private void InsertReceipt(CreateReceiptViewModel model) { int uId; decimal price; if (!int.TryParse(model.UserId, out uId) || !decimal.TryParse(model.ReceiptTotal, out price)) return; var receipt = new Receipt { UserId = uId, ReceiptName = model.ReceiptName, TotalPrice = price, ReceiptDate = model.ReceiptDate }; _receiptService.InsertReceipt(receipt); }
public void InsertReceipt(Receipt receipt) { if (receipt.UserId > 0) _receiptRepository.Insert(receipt); }