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;
}