private void SaveSettlement(SqlConnection conn, SqlTransaction trans)
{
var oSettlement = new Settlement();
oSettlement.UserID = txtCashierID.Text.Trim();
oSettlement.Date = dtpSettlementDate.Value.Date;
oSettlement.IsDeleted = false;
for (int i = 0; i < gridSettlement.Rows.Count; ++i)
{
oSettlement.PaymentMethodID = Convert.ToString(gridSettlement.Rows[i].Cells[gridSettlement.Columns["PaymentMethodID"].Index].Value);
oSettlement.Amount = Convert.ToDecimal(gridSettlement.Rows[i].Cells[gridSettlement.Columns["Amount"].Index].Value);
var dv = new DataView(oSettlement.SelectOneByUserIDDatePaymentmethodAmount(conn, trans));
if (dv.Count > 0)
{
dv.RowFilter = "Amount = '" + Convert.ToString(Convert.ToDecimal(gridSettlement.Rows[i].Cells[gridSettlement.Columns["Amount"].Index].Value)) + "' ";
if (!(dv.Count > 0))
{
oSettlement.Delete(conn, trans);
oSettlement.ID = BussinessRules.ID.GenerateIDNumberWithBeginTransaction("Settlement", "ID", conn, trans, "S");
oSettlement.Insert(conn, trans);
}
}
else
{
oSettlement.ID = BussinessRules.ID.GenerateIDNumberWithBeginTransaction("Settlement", "ID", conn, trans, "S");
oSettlement.Insert(conn, trans);
}
dv.Dispose();
dv = null;
}
oSettlement.Dispose();
oSettlement = null;
}
