Exemple #1
0
 public bool ConnectLinqDataBase( )
 {
     System.IO.Directory.GetCurrentDirectory();
     if (voyDatabase == null)
     {
         voyDatabase = new VoygerDatabase(pathName + "\\" + dbName);
         if (!voyDatabase.DatabaseExists())
         {
             voyDatabase.CreateDatabase();
         }
         if (voyDatabase != null && voyDatabase.Connection.State == ConnectionState.Open)
         {
             LogEvent.WriteEvent("Connected");
         }
         else
         {
             return(false);
         }
         if (voyDatabase == null)
         {
             LogEvent.WriteEvent("DataBase doesnt exsits");
         }
         else
         {
             LogEvent.WriteEvent("Database is present and running");
         }
     }
     if (voyDatabase.Connection.State == ConnectionState.Open)
     {
         LogEvent.WriteEvent("DataBase is Running");
         return(true);
     }
     else
     {
         LogEvent.WriteEvent("DataBase is not Running");
         return(false);
     }
 }
        //private Clients clients = CurrentClient.LoggedClient;

        public UploaderForm(int mode)
        {
            InitializeComponent();
            //   Mode = mode;
            ExcelFileOpenDialogg.InitialDirectory = "C:\\Users\\";
            ExcelFileOpenDialogg.FileName         = "";
            //  itemlist.Add("SaleRegister");
            // itemlist.Add("Customer");
            // itemlist.Add("SaleItemWise");
            /// itemlist.Add("Purchase");
            itemlist.Add("VoyBill");

            //itemlist.Add ("PurchaseRegister");
            for (int x = 0; x < itemlist.Count; x++)
            {
                CBUploadType.Items.Add(itemlist[x]);
            }
            CBUploadType.SelectedIndex = 0;
            //ER = new ExcelToDataBase();
            // EDB = new UploaderFormVM();
            db = new VoygerDatabase(InsertData.pathName + "\\" + InsertData.dbName);
            //db.DeleteDatabase();
            //db.CreateDatabase();
        }