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);
}
}
}
}
