private void FetchServerData() { tranids = string.Empty; progressPanel1.Visible = true; Application.DoEvents(); _dsdownload.Clear(); string cnstr = new SqlAsyncConnectionString(6, true); // string _syncConstr = new SqlAsyncConnectionString(6, true); if (Utils.Company == "01" || Utils.Company == "00") { cnstr = Utils.ConnectionstringSync;//_constr = VIRETAILDAL.COMMON.Utils.Connectionstring; } var bl = new ItemDownLoadDataManager(); try { string maxtran = new Blitemmove().GetMaxTranid(); _negativestockmaster = bl.GetNegativeStock(); bl.GetServerData(ref _ds, cnstr, maxtran); if (DoStartPusingData(true)) { ////////new RemoteSync().UpDateRemoteTransferMain(_ds.ITEMTRANSFERMAIN); XtraMessageBox.Show("Down load finish", "POS", MessageBoxButtons.OK,MessageBoxIcon.Information); } } catch (Exception ex) { XtraMessageBox.Show(ex.ToString()); } }
private void DoSave(bool downall = false) { if (lookupto.GetColumnValue("COMPANY").ToString() != Utils.Company) { var dr = _dsdownload.NewRow(); dr[0] = _ds.ITEMTRANSFERMAIN[0]["TRANID"].ToString(); dr[1] = _ds.ITEMTRANSFERMAIN[0]["TRANDATE"].ToString(); dr[2] = _ds.ITEMTRANSFERMAIN[0]["FRMNAME"].ToString(); dr[3] = "File not belongs your store"; _dsdownload.Rows.Add(dr); return; } btnbrowse.Enabled = false; btnsave.Enabled = false; var blitemmove = new Blitemmove(); foreach (DataRow d in _ds.ITEMTRANSFERMAIN.Rows) { blitemmove.Tranid = d["TRANID"].ToString(); if (d["TOCOMP"].ToString() != Utils.Company) { var dr = _dsdownload.NewRow(); //dr[0] = _ds.ITEMTRANSFERMAIN[0]["TRANID"].ToString(); //dr[1] = _ds.ITEMTRANSFERMAIN[0]["TRANDATE"].ToString(); //dr[2] = _ds.ITEMTRANSFERMAIN[0]["FRMNAME"].ToString(); dr[0] = d["TRANID"].ToString(); dr[1] = d["TRANDATE"].ToString(); dr[2] = d["FRMNAME"].ToString(); dr[3] = "File not belongs your store"; _dsdownload.Rows.Add(dr); } else { blitemmove.GetItemMoveByTranid(); if (blitemmove.Itemtransferdetail.Rows.Count > 0) { var dr = _dsdownload.NewRow(); dr[0] = d["TRANID"].ToString(); dr[1] = d["TRANDATE"].ToString(); dr[2] = d["FRMNAME"].ToString(); dr[3] = "File already download"; _dsdownload.Rows.Add(dr); } else { var dr = _dsdownload.NewRow(); dr[0] = d["TRANID"].ToString(); dr[1] = d["TRANDATE"].ToString(); dr[2] = d["FRMNAME"].ToString(); var bl = new ItemDownLoadDataManager {whid = lookupto.EditValue.ToString()}; var retval = bl.DoSave(_ds, dr[0].ToString(), downall); if (retval == "1") { new RemoteSync().UpDateRemoteTransferMain(dr[0].ToString()); tranids += dr[0] + ","; // SetUpdateFlagInServer() dr[3] = "Data Download Sucessfully"; if (_negativestockmaster.Rows.Count > 0) { var f = new FrmNegativeStockReplace {GetDsInventory = _negativestockmaster}; f.Show(); } } else { dr[3] = "Error" + retval; btnbrowse.Enabled = true; btnsave.Enabled = true; } _dsdownload.Rows.Add(dr); } } } }