public MainForm() { InitializeComponent(); toolStripStatusLabel4.Text = "Klar"; baseDB = new inventoryBaseEntities(); _appCore = new AppCore(); _appServiceExcel = new AppService_ExcelImport(); _appCore.OnUpdateStatus += new AppCore.StatusUpdateHandler(ShowLoadDBUpdate); _appServiceExcel.OnUpdateStatus += new AppService_ExcelImport.StatusUpdateHandler(ShowLoadExcelUpdate); _appEventlog = new AppEventLogger(); tabControl1.SelectedIndex = 1; try { baseDB.Database.Connection.Open(); } catch (Exception ex) { _appEventlog.writeError(ex.Message, ex.StackTrace); MessageBox.Show("Fejl i forbindelse til databasen! Se eventuelt eventlog", "Fejl", MessageBoxButtons.OK); System.Threading.Thread.Sleep(2000); EndApplication(); } //Preloading suppliers and productCatalog to Dictonaries in _appCore _appCore.preloadSuppliers(); _appCore.preloadProducCatalog(); }
public object findProductByNumber(string barCodeIn) { object oProduct = null; using (inventoryBaseEntities ivb = new inventoryBaseEntities()) { try { var query = (from q in ivb.activeInventory where q.serialNo.Equals(barCodeIn) select q).FirstOrDefault(); oProduct = query; } catch (Exception ex) { AppEventLogger log = new AppEventLogger(); log.writeError(ex.Message, ex.StackTrace); } finally { ivb.Dispose(); } } return oProduct; }
public void findProductNr(string barcode) { using (inventoryBaseEntities ivb = new inventoryBaseEntities()) { try { } catch(Exception ex) { AppEventLogger log = new AppEventLogger(); log.writeError(ex.Message, ex.StackTrace); } } }
public void preloadSuppliers() { Dictionary<string, int> _preSuppilers = new Dictionary<string, int>(); using (inventoryBaseEntities ivb = new inventoryBaseEntities()) { try { var query = (from q in ivb.suppliers select q); foreach (suppliers itm in query) { _preSuppilers.Add(itm.name, itm.id); } } catch (Exception ex) { _appEventlog.writeError(ex.Message, ex.StackTrace); } } PreloadedSuppliers = _preSuppilers; }
public void preloadProducCatalog() { Dictionary<string, int> _preProductCatalog = new Dictionary<string, int>(); using (inventoryBaseEntities ivb = new inventoryBaseEntities()) { try { var query = (from q in ivb.productCatalog select q); foreach (productCatalog itm in query) { if (!itm.prShortName.Equals(null)) { _preProductCatalog.Add(itm.prShortName, (int)itm.prNumber); } } } catch (Exception ex) { _appEventlog.writeError(ex.Message, ex.StackTrace); } } PreloadedProductCatalog = _preProductCatalog; }
public void loadSunpower(List<DataSet> excelList, int startRow, int cnameRow, int cnameCol, string mfgBy) { Stopwatch queryTimer = new Stopwatch(); if (Properties.Settings.Default.debug) { queryTimer.Start(); } UpdateStatus("Indlæser til Database"); using (inventoryBaseEntities ivb = new inventoryBaseEntities()) { try { foreach (DataSet ds in excelList) { string[] cName = ((string)ds.Tables[0].Rows[cnameRow].ItemArray[cnameCol]).Split(' '); string prShortName = cName[0]; for (int i = startRow; i < ds.Tables[0].Rows.Count; i++) { if (((String)ds.Tables[0].Rows[i].ItemArray[0]).Length > 2) { string testSerial = (string)ds.Tables[0].Rows[i].ItemArray[0]; var query = (from q in ivb.panels where q.panelSerial.Equals(testSerial) select q.panelSerial); if (query.Count() < 1) { if (Properties.Settings.Default.debug) { _appEventlog.writeInfo("Opslag efter producent og produkt nr.: " + queryTimer.Elapsed.ToString()); queryTimer.Reset(); queryTimer.Start(); } panels p = new panels(); p.panelSupplier = (from q in PreloadedSuppliers where q.Key.Contains(mfgBy) select q).First().Value; p.panelCname = cName[0]; p.prodNo = (from q in PreloadedProductCatalog where q.Key.Contains(prShortName) select q).First().Value; p.panelSerial = (string)ds.Tables[0].Rows[i].ItemArray[0]; p.panelEff = Double.Parse(ds.Tables[0].Rows[i].ItemArray[3].ToString(), CultureInfo.CurrentCulture); p.panelVmp = Double.Parse(ds.Tables[0].Rows[i].ItemArray[4].ToString(), CultureInfo.CurrentCulture); p.panelVoc = Double.Parse(ds.Tables[0].Rows[i].ItemArray[5].ToString(), CultureInfo.CurrentCulture); p.panelImp = Double.Parse(ds.Tables[0].Rows[i].ItemArray[6].ToString(), CultureInfo.CurrentCulture); p.panelIsc = Double.Parse(ds.Tables[0].Rows[i].ItemArray[7].ToString(), CultureInfo.CurrentCulture); p.panelFf = Double.Parse(ds.Tables[0].Rows[i].ItemArray[8].ToString(), CultureInfo.CurrentCulture); ivb.panels.Add(p); if (Properties.Settings.Default.debug) { queryTimer.Stop(); _appEventlog.writeInfo("Oprettelse af panel i dataset " + queryTimer.Elapsed.ToString()); queryTimer.Reset(); } } else { _appEventlog.writeWarning("Panel med serie nr.: " + (string)ds.Tables[0].Rows[i].ItemArray[0].ToString() + " findes allerede i databasen (dobbelt indlæsning)"); if (Properties.Settings.Default.debug) { Console.WriteLine("Panel med serie nr.: " + (string)ds.Tables[0].Rows[i].ItemArray[0].ToString() + " findes allerede i databasen (dobbelt indlæsning)"); } } } } } //Commit all panels to DB ivb.SaveChanges(); } catch (Exception ex) { _appEventlog.writeError(ex.Message, ex.StackTrace); } finally { if (Properties.Settings.Default.debug) { queryTimer.Stop(); UpdateStatus("Indlæst til database"); _appEventlog.writeInfo("Database indlæsning tog: " + queryTimer.Elapsed.ToString()); UpdateStatus("Klar"); } //Disposeing database entity ivb.Dispose(); } } }
public string getCity(string postCode) { int code = Int32.Parse(postCode); string city = ""; using (inventoryBaseEntities ivb = new inventoryBaseEntities()) { try { var query = (from q in ivb.postCodes where q.postCode == code select q.cityName).FirstOrDefault(); city = query.ToString(); } catch (Exception ex) { AppEventLogger log = new AppEventLogger(); log.writeError(ex.Message, ex.StackTrace); } finally { ivb.Dispose(); } } return city; }