public void UpdateSalesMain(DataRow dr) { //string retval = "1"; //try //{ var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter { Connection = { ConnectionString = _constr } }; ta.Update(dr); // var t = ta.Insert(sinvo, null, null, null, null, null, null, null, null, salesman, doctorid, // Utils.Company, // shiftcode, null, null, hold, compname, null, false, DateTime.Now, null, null, null, // null, null, null, 0, 0, 0, 0, false, 0, 0, 0, false, false) > 0; //} //catch (Exception ex) //{ // retval = ex.ToString(); //} //return retval; }
public DsInventory.SALESMAINDataTable GetHoldedInvoices(string compname) { var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsInventory(); ta.FillByHold(ds.SALESMAIN, compname); return ds.SALESMAIN; }
public DsInventory.SALESMAINDataTable GetSalesInvMainBySinvno(string sinvno) { var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsInventory().SALESMAIN; ta.FillBySINVNO(ds,sinvno); return ds; }
public void DeleteSalesInvMain(string sinvno) { var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter() {Connection = {ConnectionString = _constr}}; ta.DeleteSalesInvMainOnly(sinvno); }
public void GetNonSaleInv() { var tasalMain = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}}; var tasaldetail = new DsInventoryTableAdapters.SALESINVDETAILTableAdapter {Connection = {ConnectionString = _constr}}; var ds = new DsInventory(); tasalMain.FillByNonPost(ds.SALESMAIN, Environment.MachineName); if (ds.SALESMAIN.Rows.Count > 0) { salesmainRow = ds.SALESMAIN[0]; var sinvno = salesmainRow[0].ToString(); try { tasaldetail.FillBySINVNO(ds.SALESINVDETAIL, sinvno); salesinvdetailData = ds.SALESINVDETAIL; } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.ToString()); } } }
public DsInventory.SALESMAINDataTable GetSalesInvMain(string invno, bool issale = false, bool hold = false) { var ds = new DsInventory.SALESMAINDataTable(); var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}}; ta.FillByInvno(ds, invno, issale, hold); return ds; }
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; }
public string DoSave(string sinvo, bool hold, int salesman, int doctorid, string shiftcode, string compname,decimal totamt=0,decimal netamt=0) { string retval = "1"; try { var ta = new DsInventoryTableAdapters.SALESMAINTableAdapter {Connection = {ConnectionString = _constr}}; var t = ta.Insert(sinvo, null, null, null, null,totamt, null, netamt, null, salesman, doctorid, Utils.Company, shiftcode, null, null, hold, compname, null, false, DateTime.Now, null, null, null, null, null, null, 0, 0, 0, 0, false, 0, 0, 0, false, false,null) > 0; } catch (Exception ex) { retval = ex.ToString(); } return retval; }