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