public PaymentBo Get(int id)
{
using (SqlConnection conn = CreateConnection())
{
using (SqlCommand cmd = CreateSpCommand("spPaymentGet", conn))
{
cmd.Parameters.AddWithValue("@Id", id);
cmd.AddVarCharOutParam("@PaymentType", 200);
cmd.AddDateTimeOutParam("@PaymentDate");
cmd.AddDecimalOutParam("@Amount", 16, 2);
cmd.AddDateTimeOutParam("@CreationDate");
cmd.AddDateTimeOutParam("@ChangeDate");
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
var bo = new PaymentBo();
bo.Id = id;
bo.PaymentType = cmd.GetParamValue<int>("@PaymentType");
bo.PaymentDate = cmd.GetParamValue<DateTime>("@PaymentDate");
bo.Amount = cmd.GetParamValue<decimal>("@PaymentDate");
bo.CreationDate = cmd.GetParamValue<DateTime>("@CreationDate");
bo.ChangeDate = cmd.GetParamValue<DateTime>("@ChangeDate");
return bo;
}
}
}
public void Save(PaymentBo bo)
{
if (bo.IsNewRecord)
{
Insert(bo);
}
else
{
Update(bo);
}
}
private void Insert(PaymentBo bo)
{
using (SqlConnection conn = CreateConnection())
{
using (SqlCommand cmd = CreateSpCommand("spPaymentIns", conn))
{
cmd.AddIntOutParam("@Id");
cmd.Parameters.AddWithNullableValue("@PaymentType", bo.PaymentType);
cmd.Parameters.AddWithNullableValue("@PaymentDate", bo.PaymentDate);
cmd.Parameters.AddWithValue("@Amount", bo.Amount);
cmd.AddDateTimeOutParam("@CreationDate");
cmd.AddDateTimeOutParam("@ChangeDate");
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
bo.Id = cmd.GetParamValue<int>("@Id");
bo.CreationDate = cmd.GetParamValue<DateTime>("@CreationDate");
bo.ChangeDate = cmd.GetParamValue<DateTime>("@ChangeDate");
}
}
}
public void SetCurrentId(int currentId)
{
_currentPaymentBo = _paymentRepository.Get(currentId);
}