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