public string DoSave() { string retval = "0"; SqlTransaction tran = null; try { var cn = new SqlConnection { ConnectionString = _constr }; cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var dm = new DataManager(); var dt = new Ledgers.APARMAINDataTable(); var ta = new LedgersTableAdapters.APARMAINTableAdapter {Connection = {ConnectionString = _constr}}; ta.Fill(dt); var taleder = new LedgersTableAdapters.LEDGERSTableAdapter(); taleder.AssignConnection(cn,tran); ta.AssignConnection(cn, tran); var tasalesamtdetails = new LedgersTableAdapters.SalesAmountDetailsTableAdapter(); tasalesamtdetails.AssignConnection(cn, tran); var autoid = dm.GetAutoId(17); autoid++; Utils.CustomerReceipt = dm.CreateFormatedAutoNo(autoid); ta.Update(AparmainData); var bl = new SalesManger().GetInvoiceNo(17); taleder.Insert("C", customerno, trandate, trandate, Utils.CustomerReceipt, Utils.CustomerReceipt,0 , AppliedAmt, 17, Utils.Company, Utils.Userid, "Customer Receipt"); tasalesamtdetails.Insert(trandate, null, customerno, "C", amountype, AppliedAmt, shiftcode, false, Utils.Company,userid, false, null); tran.Commit(); retval = "1"; } catch (Exception ex) { retval = ex.ToString(); if (tran != null) tran.Rollback(); } return retval; }
public string DoSave() { SqlTransaction tran = null; var retval = "0"; try { var dsStockWithItemcodes = GetStockTableWithItemCodes(salesinvdetailData); var cn = new SqlConnection(_constr); cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var ds = new DsInventory(); var dt = ds.SALESMAIN; var tasalMain = new DsInventoryTableAdapters.SALESMAINTableAdapter(); var tasalDetail = new DsInventoryTableAdapters.SALESINVDETAILTableAdapter(); var tasalesamtdetails = new LedgersTableAdapters.SalesAmountDetailsTableAdapter(); tasalesamtdetails.AssignConnection(cn, tran); tasalMain.Connection.ConnectionString = _constr; // tasalMain.Fill(dt); tasalMain.FillBySINVNO(dt,salesmainRow.SINVNO); tasalMain.AssignConnection(cn, tran); tasalDetail.AssignConnection(cn, tran); var dr = dt.FindBySINVNO(salesmainRow.SINVNO); bool isnew = false; if (dr != null) { dr.BeginEdit(); dr.EndEdit(); } else { dr = (DsInventory.SALESMAINRow) dt.NewRow(); dr.ItemArray = salesmainRow.ItemArray; isnew = true; } if (isnew) { dt.Rows.Add(dr); tasalMain.Update(dt); } else { tasalMain.Update(salesmainRow); } //salesmainRow.SALESTYPE if (salesmainRow.SALESTYPE == "I" || salesmainRow.SALESTYPE == "C") { var taaparleder = new LedgersTableAdapters.APARMAINTableAdapter(); var taledger = new LedgersTableAdapters.LEDGERSTableAdapter(); taledger.AssignConnection(cn, tran); taaparleder.AssignConnection(cn, tran); var netamt = 0m; var totaldiscper = 0m; if (salesmainRow.SALESTYPE == "I") { totaldiscper = salesmainRow.CUSTOMERFIXDISC ; netamt = salesmainRow.CREDITAMT; } else { netamt = salesmainRow.CREDITAMT; totaldiscper = salesmainRow.CUSTOMERFIXDISC ; } if (netamt > 0) { string cdno = ""; if (!salesmainRow.IsCARDNONull()) cdno = salesmainRow.CARDNO.ToString(); taaparleder.Insert("C", salesmainRow.CUSTOMERID, salesmainRow.TRANDATE, salesmainRow.TRANDATE, cdno, salesmainRow.SINVNO, netamt, 0, netamt, salesmainRow.COMPANY, 3, salesmainRow.SALESMAN, totaldiscper); taledger.Insert("C", salesmainRow.CUSTOMERID, salesmainRow.TRANDATE, salesmainRow.TRANDATE, cdno, salesmainRow.SINVNO, netamt, 0, 3, salesmainRow.COMPANY, Utils.Userid, "Sales Invoice"); } } foreach (DsInventory.SALESINVDETAILRow drstk in salesinvdetailData.Rows) { if(!drstk.IsSTOCKIDNull()) { if(drstk.STOCKID > 0) { if (drstk.ISRETURN) { UpdateStockQty(ref cn, ref tran, drstk.STOCKID, (drstk.QTY * -1), drstk); } else { UpdateStockQty(ref cn, ref tran, drstk.STOCKID, -drstk.QTY, drstk); } } else { if (drstk.ISRETURN) { AddNewItemItemInStock(ref cn, ref tran, drstk, dsStockWithItemcodes); } } } } tasalDetail.Update(salesinvdetailData); tasalesamtdetails.Update(SalesAmount); tran.Commit(); retval = "1"; } catch (Exception ex) { retval = ex.ToString(); tran.Rollback(); } return retval; }