Esempio n. 1
0
 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;
 }
Esempio n. 2
0
 public bool SyncBMCSubBricks(mdlDataSync obj_mdlDataSync)
 {
     return obj_dalDataSync.SyncBMCSubBricks(obj_mdlDataSync);
 }
Esempio n. 3
0
 public bool SyncBMCTerritories(mdlDataSync obj_mdlDataSync)
 {
     return obj_dalDataSync.SyncBMCTerritories(obj_mdlDataSync);
 }
Esempio n. 4
0
 public bool SyncBMCProducts(mdlDataSync obj_mdlDataSync)
 {
     return obj_dalDataSync.SyncBMCProducts(obj_mdlDataSync);
 }
Esempio n. 5
0
 public bool SyncBMCOCGroups(mdlDataSync obj_mdlDataSync)
 {
     return obj_dalDataSync.SyncBMCOCGroups(obj_mdlDataSync);
 }
Esempio n. 6
0
 public bool SyncBMCEmployees(mdlDataSync obj_mdlDataSync)
 {
     return obj_dalDataSync.SyncBMCEmployees(obj_mdlDataSync);
 }
Esempio n. 7
0
 public bool SyncBMCCustomer(mdlDataSync obj_mdlDataSync)
 {
     return obj_dalDataSync.SyncBMCCustomer(obj_mdlDataSync);
 }
Esempio n. 8
0
 public bool SyncBMCCompanies(mdlDataSync obj_mdlDataSync)
 {
     return obj_dalDataSync.SyncBMCCompanies(obj_mdlDataSync);
 }