void DouploadCustomerRedimPoints()
{
txtstatus.Caption = "Uploading Customer Points";
Application.DoEvents();
try
{
var dm = new VIRETAILDAL.Masters.Customer();
var dt = dm.GetCustomerPointNotUploaded();
var syc = new RemoteSync();
if (dt.Rows.Count <= 0) return;
foreach (Ledgers.CUSTOMERPOINTSRow dr in dt.Rows)
{
var drd1 = _dsdownload.NewRow();
var ret = syc.UpdatePointsDetails(dr); //syc.DoSavePurchaseRequestInRemote(dm.GetPurchaseRequstNotSync());
if (ret == "1")
{
dm.SetCustomerPointUploadStatus(dr.TID);
drd1[1] = DateTime.Now.Date;
drd1[2] = "Customer Points re-dim details";
drd1[3] = "Re-dim Updated";
}
else
{
drd1[3] = "Error " + ret;
}
_dsdownload.Rows.Add(drd1);
}
}
catch (Exception exp)
{
XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
void DoDownLoadCustomers()
{
txtstatus.Caption = "Uploading Customer Price";
Application.DoEvents();
try
{
var syc = new RemoteSync();
var drd = _dsdownload.NewRow();
if(syc.DoDownLoadCustomer()=="1")
{
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Customer";
drd[3] = "Customer Download";
}
else
{
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Customer";
drd[3] = "Error Downloading";
}
_dsdownload.Rows.Add(drd);
}
catch (Exception exp)
{
XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
void DoUploadCustomerPoints()
{
txtstatus.Caption = "Uploading Customer Points";
Application.DoEvents();
try
{
var dm = new VIRETAILDAL.Masters.Customer();
var dt = dm.GetCustomerWithPoints();
var syc = new RemoteSync();
if (dt.Rows.Count == 0)
{
var drd = _dsdownload.NewRow();
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Customer Points";
drd[3] = "Nothing to Upload ";
_dsdownload.Rows.Add(drd);
}
else
{
foreach (DsMaster.CUSTOMERRow dr in dt.Rows)
{
var drd1 = _dsdownload.NewRow();
var ret = syc.SetAvailablePoints(dr.CUSTNO, dr.CUSTOMERPOINT); //syc.DoSavePurchaseRequestInRemote(dm.GetPurchaseRequstNotSync());
if (ret == "1")
{
dm.UpdateCustomerPoints(dr.CUSTNO, -dr.CUSTOMERPOINT);
drd1[1] = DateTime.Now.Date;
drd1[2] = "Customer Points";
drd1[3] = "Points Updated";
}
else
{
drd1[3] = "Error " + ret;
}
_dsdownload.Rows.Add(drd1);
}
}
}
catch (Exception exp)
{
XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
void DoUpLoadSuppliers()
{
if (Utils.PingServer())
{
var syc = new RemoteSync();
var ret = syc.DoUpLoadSuppliers();
if (ret != "1")
{
XtraMessageBox.Show(ret, "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
XtraMessageBox.Show("Failed to connect server ", "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
void DoDownLoadPromotions()
{
txtstatus.Caption = "Downloading Promotions";
Application.DoEvents();
try
{
var dm = new BlCommissionSetup();
var dt = dm.GetCommissonMastNotReceived();
var syc = new RemoteSync();
if (Utils.PingServer() )
{
if (dt.Rows.Count == 0)
{
var drd = _dsdownload.NewRow();
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Commission Invoice";
drd[3] = "Nothing to Download";
_dsdownload.Rows.Add(drd);
}
}
else
{
XtraMessageBox.Show("Failed to connect server ", "POS", MessageBoxButtons.OK,MessageBoxIcon.Information);
}
foreach (Ledgers.COMMISIONMASTRow dr in dt.Rows)
{
if (Utils.PingServer())
{
var drd = _dsdownload.NewRow();
drd[0] = dr.COMID;
drd[1] = DateTime.Now.Date;
drd[2] = "Commission Invoice";
var ret = syc.DoUpLoadPromotions(dr, dm.GetCommissionDetail(dr.COMID, true), true);
if (ret == "1")
{
drd[3] = "Downloaded";
}
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);
}
}
void DoUploadItemTransfers()
{
txtstatus.Caption = "Uploading Item Transfer";
Application.DoEvents();
progressPanel1.Visible = true;
try
{
var dm = new ItemMoveDataManager();
var dt = dm.GetItemTranferToTransfer();
var syc = new RemoteSync();
var dtw = ClsGetData.GetMyWareHouses();
bool isStore = dtw.Rows.Count > 0;
if (dt.Rows.Count == 0)
{
var drd = _dsdownload.NewRow();
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Item transfer";
drd[3] = "Nothing to Upload ";
_dsdownload.Rows.Add(drd);
return;
}
foreach (DsInventory.ITEMTRANSFERMAINRow dr in dt.Rows)
{
//if (Utils.PingServer())
//{
if (isStore)
{
var drd1 = _dsdownload.NewRow();
var retval = syc.DoUpLoadItems(dr.TRANID, false);
if (retval == "1")
{
drd1[0] = dr.TRANID;
drd1[1] = DateTime.Now.Date;
drd1[2] = "Item Master - Item Transfer";
drd1[3] = "Upload ";
}
else
{
drd1[0] = dr.TRANID;
drd1[1] = DateTime.Now.Date;
drd1[2] = "Item Master - Item Transfer";
drd1[3] = "Error '" + retval + "'";
}
_dsdownload.Rows.Add(drd1);
}
var drd = _dsdownload.NewRow();
drd[0] = dr.TRANID;
drd[1] = DateTime.Now.Date;
drd[2] = "Item transfer";
var ret = syc.DoSaveItemTranferInRemote(dr, dm.GetItemTransferDetailById(dr.TRANID));
if (ret == "1")
{
dm.UpdatedSyn(dr.TRANID);
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);
}
}
void DoUploadMaterialRequest()
{
txtstatus.Caption = "Uploading Material Request";
Application.DoEvents();
try
{
var dm = new PrDataManager();
var dt = dm.GetPurchaseRequstNotSync();
var syc = new RemoteSync();
var drd = _dsdownload.NewRow();
if (dt.Rows.Count == 0)
{
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Material Request";
drd[3] = "Nothing to Upload ";
_dsdownload.Rows.Add(drd);
}
else
{
var ret = syc.DoSavePurchaseRequestInRemote(dm.GetPurchaseRequstNotSync());
if (ret == "1")
{
dm.DoUpdateSync();
drd[2] = "Material Request";
drd[3] = "Uploaded";
}
else
{
drd[3] = "Error " + ret;
}
_dsdownload.Rows.Add(drd);
}
}
catch (Exception exp)
{
XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
void DoUploadItemsPrices(bool upload)
{
txtstatus.Caption = "Uploading Sales Price";
Application.DoEvents();
try
{
var dm = new PromotionPrice() ;
var dt = upload ? dm.GetDataForDownload() : dm.GetDataForUpload();
var syc = new RemoteSync();
if (dt.Rows.Count == 0)
{
var drd = _dsdownload.NewRow();
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Promotion Items";
drd[3] = "Nothing to Upload ";
_dsdownload.Rows.Add(drd);
}
else
{
var drd = _dsdownload.NewRow();
drd[1] = DateTime.Now.Date;
drd[2] = "Promotion Items";
var ret = syc.DoUploadPromotionItems(dt, upload);
if (ret == "1")
{
foreach (DataRow dri in dt.Rows)
{
dm.UpdateSync(int.Parse(dri[0].ToString()));
}
drd[3] = "Uploaded";
}
else
{
drd[3] = "Error " + ret;
}
_dsdownload.Rows.Add(drd);
}
}
catch (Exception exp)
{
XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
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);
}
}
void DoUploadPurchases()
{
txtstatus.Caption = "Uploading Purchases";
Application.DoEvents();
try
{
var dm = new PurInvDataManager();
var dt = dm.GetPurchaseInvoiceNotSync();
var syc = new RemoteSync();
// GetMasters(dt, true);
// syc.DoUpLoadItems(_Purinvids, true);
if (dt.Rows.Count == 0)
{
var drd = _dsdownload.NewRow();
drd[0] = "";
drd[1] = DateTime.Now.Date;
drd[2] = "Purchase Invoice";
drd[3] = "Nothing to Upload ";
_dsdownload.Rows.Add(drd);
}
foreach (DsPurchase.PURINVMAINRow dr in dt.Rows)
{
if (Utils.PingServer())
{
//syc.DoUpLoadItems(dr.PURINVID, true);
var drd1 = _dsdownload.NewRow();
var retval = syc.DoUpLoadItems(dr.PURINVID, true);
if (retval == "1")
{
drd1[0] = dr.PURINVID;
drd1[1] = DateTime.Now.Date;
drd1[2] = "Item Master - Purchase Invoice ";
drd1[3] = "Upload ";
}
else
{
drd1[0] = dr.PURINVID;
drd1[1] = DateTime.Now.Date;
drd1[2] = "Item Master - Purchase Invoice ";
drd1[3] = "Error '" + retval + "'";
}
_dsdownload.Rows.Add(drd1);
// Purchase invoice
var drd = _dsdownload.NewRow();
drd[0] = dr.PURINVID;
drd[1] = DateTime.Now.Date;
drd[2] = "Purchase Invoice";
var ret = syc.DoSavePurchaseInvoiceInRemote(dr, dm.GetPurInvDetailsById(dr.PURINVID));
if (ret == "1")
{
dm.UpdatedSyn(dr.PURINVID);
drd[3] = "Uploaded";
}
else
{
drd[3] = "Error " + ret;
}
_dsdownload.Rows.Add(drd);
// Purchase invoice
}
else
{
XtraMessageBox.Show("Failed to connect server ", "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
}
catch(Exception exp)
{
XtraMessageBox.Show(exp.ToString(), "POS", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
