public string DoDeleteInvoice(Ledgers.ARAPRECEIPTSDETAILSRow dr) { SqlTransaction tran = null; var isnew = false; string retval = string.Empty; try { var cn = new SqlConnection(_constr); cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var taLedger = new LEDGERSTableAdapter(); taLedger.AssignConnection(cn, tran); //ARAPRECEIPTSDETAILS // var cmd = new SqlCommand(cmdtxt, cn, tran); var cmd = new SqlCommand(); cmd.Connection = cn; cmd.Transaction = tran; var cmdtxt = "delete from ARAPRECEIPTSDETAILS where tranid = " + dr.TRANID + ""; cmd.CommandText = cmdtxt; cmd.ExecuteNonQuery(); cmdtxt = "update ARAPRECEIPTS set AMOUNT = AMOUNT - " + dr.INVAMOUNT + " where ARAPTRANID =" + dr.ARAPTRANID; cmd.CommandText = cmdtxt; cmd.ExecuteNonQuery(); cmdtxt = "update APARMAIN set BALANCE = " + dr.INVAMOUNT + " , PAIDAMOUNT = 0 where tranid = " + dr.TRANID; cmd.CommandText = cmdtxt; cmd.ExecuteNonQuery(); taLedger.Insert("S", dr.REFNO, DateTime.Now.Date, dr.INVOICEDATE, dr.ARAPTRANID, dr.INVOICENO, - dr.INVAMOUNT, 0, 18, Utils.Company, Utils.Userid, "Purchase Reverse"); tran.Commit(); retval = "1"; } catch (Exception ex) { tran.Rollback(); retval = ex.ToString(); } return retval; }
public string DoPost(string batchno,Ledgers.ARAPRECEIPTSDETAILSDataTable dt) { string retval = string.Empty; SqlTransaction tran = null; try { var cn = new SqlConnection(_constr); cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var ta = new ARAPRECEIPTSTableAdapter(); var tadet = new ARAPRECEIPTSDETAILSTableAdapter(); var taLedger = new LEDGERSTableAdapter(); ta.AssignConnection(cn,tran);// tadet.AssignConnection(cn,tran); taLedger.AssignConnection(cn,tran); string arapno = string.Empty; foreach (Ledgers.ARAPRECEIPTSDETAILSRow drdet in dt.Rows) { if (drdet.RowState != DataRowState.Deleted) { arapno = drdet.ARAPTRANID; var cmdtxt = "update APARMAIN set PAIDAMOUNT = 0 , BALANCE = INVAMOUNT where TRANID = " + drdet.TRANID; var cmd = new SqlCommand(cmdtxt, cn, tran); cmd.ExecuteNonQuery(); taLedger.Insert("S", drdet.REFNO, DateTime.Now.Date, drdet.INVOICEDATE, batchno, drdet.INVOICENO, - drdet.INVAMOUNT, 0, 18, Utils.Company, Utils.Userid,"Payment Reverse"); } } tran.Commit(); //tadet.DeleteByARAPTRANID(batchno); //ta.DeleteByARAPTRANID(batchno); ta.DoPost(batchno); retval = "1"; } catch (Exception ex) { if (tran != null) tran.Rollback(); retval = ex.ToString(); } return retval; }