public bool SyncBMCCustomer(mdlDataSync obj_mdlDataSync)
{
bool isSyncSuccessFul = false;
try
{
obj_mdlDataSync.TargetConnectionString = "Data Source=" + obj_mdlDataSync.TargetServer + ";Initial Catalog=" + obj_mdlDataSync.TargetDatabase + ";User ID=" + obj_mdlDataSync.TargetUser + "; Password ="******";Packet Size=4096; TrustServerCertificate=True; Encrypt = True";
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.ConnectionString = obj_mdlDataSync.TargetConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand("stp_MERG_M_Customers_MPOSCustomers", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.Add("@CONN", SqlDbType.NVarChar).Value = obj_mdlDataSync.SourceConnectionString;
cmd.Parameters.Add("@SQLDB", SqlDbType.NVarChar).Value = obj_mdlDataSync.SourceDatabase;
cmd.ExecuteNonQuery();
isSyncSuccessFul = true;
}
catch (Exception)
{
isSyncSuccessFul = false;
//MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return isSyncSuccessFul;
}
public bool SyncBMCSubBricks(mdlDataSync obj_mdlDataSync)
{
return obj_dalDataSync.SyncBMCSubBricks(obj_mdlDataSync);
}
public bool SyncBMCTerritories(mdlDataSync obj_mdlDataSync)
{
return obj_dalDataSync.SyncBMCTerritories(obj_mdlDataSync);
}
public bool SyncBMCProducts(mdlDataSync obj_mdlDataSync)
{
return obj_dalDataSync.SyncBMCProducts(obj_mdlDataSync);
}
public bool SyncBMCOCGroups(mdlDataSync obj_mdlDataSync)
{
return obj_dalDataSync.SyncBMCOCGroups(obj_mdlDataSync);
}
public bool SyncBMCEmployees(mdlDataSync obj_mdlDataSync)
{
return obj_dalDataSync.SyncBMCEmployees(obj_mdlDataSync);
}
public bool SyncBMCCustomer(mdlDataSync obj_mdlDataSync)
{
return obj_dalDataSync.SyncBMCCustomer(obj_mdlDataSync);
}
public bool SyncBMCCompanies(mdlDataSync obj_mdlDataSync)
{
return obj_dalDataSync.SyncBMCCompanies(obj_mdlDataSync);
}