public static void DeletePurRetInv(string purid) { var dm = new PurReturnDataManger(); dm.DeletePurRetInv(purid, Utils.Company); }
public string DoSave() { var dm = new PurReturnDataManger(); var retval = dm.DoSave(RetinvmainRow, Retinvdetail); if (retval == "1") { Retinvid = Utils.Retinvid; } return retval; //string retval; // SqlTransaction tran = null; // var isnew = false; // try // { // var cn = new SqlConnection(Properties.Settings.Default.POSConnectionString); // cn.Open(); // tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); // var ds = new DsInventory(); // var dt = ds.RETURNMAST; // var dm = new DataManager(); // var taPurMain = new RETURNMASTTableAdapter(); // var taPurDetail = new RETURNDETAILTableAdapter(); // var taStockMaster = new STOCKMASTERTableAdapter(); // taStockMaster.Fill(ds.STOCKMASTER); // taPurMain.Fill(ds.RETURNMAST); // // Assaign Transaction // taPurMain.AssignConnection(cn, tran); // taPurDetail.AssignConnection(cn, tran); // taStockMaster.AssignConnection(cn, tran); // var dr = dt.FindByRETURNID(Retinvid); // if (dr != null) // { dr.BeginEdit(); } // else // { dr = (DsInventory.RETURNMASTRow)dt.NewRow(); } // if (string.IsNullOrEmpty(Retinvid)) // { // var autoid = dm.GetAutoId(2); // autoid++; // Retinvid = COMMON.Functions.CreateFormatedAutoNo(autoid); // dr.RETURNID = Retinvid; // dr.USERID = COMMON.Utils.Userid; // dr.COMPANY = COMMON.Utils.Company; // isnew = true; // } // else // { // dr.EDATE = DateTime.Now; // dr.EUSERID = COMMON.Utils.Userid; // } // dr.SUPID = Supid; // dr.SUPNAME = Supname; // dr.INVDATE = Invdate; // dr.INVNO = Invno; // dr.SPDISCOUNT = Spdiscount; // dr.WHID = Whid; // dr.ADJVALUE = Adjvalue; // dr.NETVALUE = Netvalue; // dr.HOLD = Hold; // if (isnew) // { // dt.Rows.Add(dr); // taPurMain.Update(dt); // } // else // { // dr.EndEdit(); // taPurMain.Update(dr); // } // foreach (DataRow purd in Retinvdetail.Rows) // { // if ((purd.RowState != DataRowState.Deleted)) // purd["RETURNID"] = Retinvid; // } // taPurDetail.Update(Retinvdetail); // if (!dr.HOLD) // { // COMMON.Functions.UpdateQtyInStockDataSet(ref ds, Retinvdetail,true); // taStockMaster.Update(ds.STOCKMASTER); // } // tran.Commit(); // dm.UpdateAutoNum(2); // retval = "1"; // } // catch (Exception ex) // { // if (tran != null) // tran.Rollback(); // if (isnew) // Retinvid = string.Empty; // retval = ex.ToString(); // } // return retval; }
void DoUploadPurchaseReturn() { txtstatus.Caption = "Uploading Purchase Return"; try { var dm = new PurReturnDataManger(); var dt = dm.GetPurchaseInvoiceReturnNotSync(); var syc = new RemoteSync(); if (dt.Rows.Count == 0) { var drd = _dsdownload.NewRow(); drd[0] = ""; drd[1] = DateTime.Now.Date; drd[2] = "Purchase Return"; drd[3] = "Nothing to Upload "; _dsdownload.Rows.Add(drd); } foreach (DsPurchase.RETURNMASTRow dr in dt.Rows) { if (Utils.PingServer()) { var drd = _dsdownload.NewRow(); drd[0] = dr.RETURNID; drd[1] = DateTime.Now.Date; drd[2] = "Purchase Return"; var ret = syc.DoSavePurchaseInvoiceReturnInRemote(dr, dm.GetPurRetInvDetailsById(dr.RETURNID)); if (ret == "1") { dm.UpdatedSynReturn(dr.RETURNID); drd[3] = "Uploaded"; } else { drd[3] = "Error " + ret; } _dsdownload.Rows.Add(drd); } else { XtraMessageBox.Show("Failed to connect server ", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception exp) { XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Information); } }