//Refreshes the entire component catalogue by removing local, and then quering the database for them all again, also rebuilds categories
public void Refresh()
{
try
{
//Check if any reservation is older than 5 days, then deletes them
cdbUtil_.CheckReservations();
AllComponentList = new ObservableCollection <Component>(cdbUtil_.GetAllComponents());
var allLoanInformationList = new ObservableCollection <LoanInformation>(ldbUtil_.GetAllLoanInformation());
loanInformationUpdaterThread_ = new Thread(() =>
{
//Set up load bar:
MaxLoadbar = AllComponentList.Count;
StatusBarText = "Henter låne information...";
LoadBarVisibility = Visibility.Visible;
foreach (LoanInformation li in allLoanInformationList)
{
foreach (Component c in AllComponentList)
{
if (li.Component == c.ComponentID)
{
c.ActualLoanInformation = li;
LoadbarProgress++;
break;
}
}
}
//Clean load bar:
StatusBarText = "Klar";
LoadbarProgress = 0;
LoadBarVisibility = Visibility.Hidden;
});
loanInformationUpdaterThread_.Start();
}
catch
{
Reconnect();
AllComponentList = new ObservableCollection <Component>();
}
Categories.Clear();
Categories.Add("Alle");
GetUniqueCategories();
SetComponentList(AllComponentList);
//SendExpLoanEmail();
}
static void Main(string[] args)
{
/* Indsæt komponent */
//for (int i = 2; i < 5; i++)
//{
// var comUtil = new ComponentDataUtil();
// var cp = new Component();
// cp.ComponentNumber = 22;
// cp.SerieNr = "123FAQ";
// cp.ComponentName = "126 nF Kondensator";
// cp.ComponentInfo = "126 nF kondensator som bare virker pisse godt og som kan bruges til bluetooth";
// comUtil.CurrentComponent = cp;
// comUtil.CreateComponent(cp);
//}
var CompDataUtil = new ComponentDataUtil();
CompDataUtil.CheckReservations();
//var cp = new Component();
//cp.ComponentNumber = 10;
//cp.ComponentName = "Test2";
//cp.SerieNr = "123ADC";
//cp.Image = "hehehelol.jpg";
////cp.Datasheet = "https://www.elfaelektronik.dk/elfa3~dk_da/elfa/init.do?item=10-389-16&toc=0&q=arduino";
//CompDataUtil.CurrentComponent = cp;
//CompDataUtil.UpdateComponent(65, cp);
//foreach (var comp in CompDataUtil.GetAllComponents())
//{
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentName + " " + comp.ComponentNumber);
//}
//CompDataUtil.DeleteComponent(3);
//var newlist = new List<string>();
//newlist.Add("Raspberry");
//newlist.Add("+");
//newlist.Add("Pi");
//foreach (var comp in CompDataUtil.GetComponents(newlist))
//{
// Console.WriteLine(comp.ComponentID + " ");
//}
//var u = new User();
//u.FirstName = "David";
//u.LastName = "Buhauer";
//u.Email = "*****@*****.**";
//userDataUtil.CurrentUser = u;
//userDataUtil.CreateUser(u);
//var u = new User();
//u.MobileNr = 76647283;
//u.FirstName = "Carl";
//userDataUtil.UpdateUser(3, u);
//userDataUtil.DeleteUser(1);
//var cp = new Component();
//cp.ComponentNumber = 10;
//cp.ComponentName = "Test2";
//cp.SerieNr = "123ADC";
//cp.Image = "hehehelol.jpg";
//cp.Datasheet = "https://www.elfaelektronik.dk/elfa3~dk_da/elfa/init.do?item=10-389-16&toc=0&q=arduino";
//var compDataUtil = new ComponentDataUtil();
//compDataUtil.UpdateComponent(108, cp);
//List<string> list = new List<string>();
//list.Add("wifi");
//list.Add("+");
//list.Add("201270915");
//List<Component> cList = compDataUtil.GetComponents(list);
//foreach (var comp in cList)
//{
// Console.WriteLine(comp.ComponentID);
//}
//compDataUtil.CreateComponent(cp);
//compDataUtil.DeleteComponent(143);
//var loanDataUtil = new LoanDataUtil();
//LoanInformation loan = new LoanInformation();
//loan.ReservationDate = new SqlDateTime(2014, 3, 15);
//loanDataUtil.UpdateLoanInformation(160, loan);
//var loan = new LoanInformation();
//loan.AdminComment = "sut mig";
//loan.UserComment = "HEHEHE";
//loan.LoanDate = new SqlDateTime();
//loan.ReturnDate = new SqlDateTime();
//loanDataUtil.UpdateLoanInformation(1, loan);
//if (compDataUtil.LoanTimeExceeded().Count > 0)
//{
// foreach (var comp in compDataUtil.LoanTimeExceeded())
// {
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentName);
// }
//}
//List<Component> comps = compDataUtil.GetAllComponents();
//loan = loanDataUtil.GetLoanInformation(comps[0]);
//Console.WriteLine(loan.LoanID + " " + loan.Component);
//loanDataUtil.UpdateLoanInformation(14, loan);
//for (int i = 1; i < compDataUtil.GetAllComponents().Count; i++)
//{
// loanDataUtil.UpdateLoanInformation(i, loan);
//}
////compDataUtil.DeleteComponent(180);
//compDataUtil.LoanTimeExceeded();
//compDataUtil.ComponentReservation("Raspberry Pi Model B 120", 1);
//foreach (var comp in loanDataUtil.GetLoanedComponents())
//{
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentName);
//}
/* Test af udlånt/reserveret komponenter for student ID med X nummer */
//Component newcomp = new Component();
//newcomp.OwnerID = 9;
//compDataUtil.UpdateComponent(1, newcomp);
//Console.WriteLine("------LÅNT-----");
//foreach (var comp in loanDataUtil.GetLoanedComponentFromStudentId("201270749"))
//{
// Console.WriteLine("---------------");
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentNumber + " " + comp.SerieNr + " "
// + comp.ComponentName + " " + comp.ComponentInfo + " " + comp.Category
// + " " + comp.Datasheet + " " + comp.Image);
// Console.WriteLine("---------------");
//}
//Console.WriteLine("---------------");
//Console.WriteLine();
//Console.WriteLine("----RESERVERET----");
//foreach (var comp in loanDataUtil.GetReservedComponentFromStudentId("201270749"))
//{
// Console.WriteLine("---------------");
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentNumber + " " + comp.SerieNr + " "
// + comp.ComponentName + " " + comp.ComponentInfo + " " + comp.Category
// + " " + comp.Datasheet + " " + comp.Image);
// Console.WriteLine("---------------");
//}
//Console.WriteLine("------------------");
//Console.WriteLine("----RESERVERING SLETTET----");
//loanDataUtil.RemoveReservation(1);
/* Test af udlånt/reserveret komponenter for student ID med X nummer */
//var loan = new LoanInformation();
//loan.LoanDate = DateTime.Now;
//loan.ReturnDate = new SqlDateTime(2014, 05, 02);
//for (int i = 1; i <= 3; i++)
// loanDataUtil.UpdateLoanInformation(i, loan);
}
static void Main(string[] args)
{
/* Indsæt komponent */
//for (int i = 2; i < 5; i++)
//{
// var comUtil = new ComponentDataUtil();
// var cp = new Component();
// cp.ComponentNumber = 22;
// cp.SerieNr = "123FAQ";
// cp.ComponentName = "126 nF Kondensator";
// cp.ComponentInfo = "126 nF kondensator som bare virker pisse godt og som kan bruges til bluetooth";
// comUtil.CurrentComponent = cp;
// comUtil.CreateComponent(cp);
//}
var CompDataUtil = new ComponentDataUtil();
CompDataUtil.CheckReservations();
//var cp = new Component();
//cp.ComponentNumber = 10;
//cp.ComponentName = "Test2";
//cp.SerieNr = "123ADC";
//cp.Image = "hehehelol.jpg";
////cp.Datasheet = "https://www.elfaelektronik.dk/elfa3~dk_da/elfa/init.do?item=10-389-16&toc=0&q=arduino";
//CompDataUtil.CurrentComponent = cp;
//CompDataUtil.UpdateComponent(65, cp);
//foreach (var comp in CompDataUtil.GetAllComponents())
//{
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentName + " " + comp.ComponentNumber);
//}
//CompDataUtil.DeleteComponent(3);
//var newlist = new List<string>();
//newlist.Add("Raspberry");
//newlist.Add("+");
//newlist.Add("Pi");
//foreach (var comp in CompDataUtil.GetComponents(newlist))
//{
// Console.WriteLine(comp.ComponentID + " ");
//}
//var u = new User();
//u.FirstName = "David";
//u.LastName = "Buhauer";
//u.Email = "*****@*****.**";
//userDataUtil.CurrentUser = u;
//userDataUtil.CreateUser(u);
//var u = new User();
//u.MobileNr = 76647283;
//u.FirstName = "Carl";
//userDataUtil.UpdateUser(3, u);
//userDataUtil.DeleteUser(1);
//var cp = new Component();
//cp.ComponentNumber = 10;
//cp.ComponentName = "Test2";
//cp.SerieNr = "123ADC";
//cp.Image = "hehehelol.jpg";
//cp.Datasheet = "https://www.elfaelektronik.dk/elfa3~dk_da/elfa/init.do?item=10-389-16&toc=0&q=arduino";
//var compDataUtil = new ComponentDataUtil();
//compDataUtil.UpdateComponent(108, cp);
//List<string> list = new List<string>();
//list.Add("wifi");
//list.Add("+");
//list.Add("201270915");
//List<Component> cList = compDataUtil.GetComponents(list);
//foreach (var comp in cList)
//{
// Console.WriteLine(comp.ComponentID);
//}
//compDataUtil.CreateComponent(cp);
//compDataUtil.DeleteComponent(143);
//var loanDataUtil = new LoanDataUtil();
//LoanInformation loan = new LoanInformation();
//loan.ReservationDate = new SqlDateTime(2014, 3, 15);
//loanDataUtil.UpdateLoanInformation(160, loan);
//var loan = new LoanInformation();
//loan.AdminComment = "sut mig";
//loan.UserComment = "HEHEHE";
//loan.LoanDate = new SqlDateTime();
//loan.ReturnDate = new SqlDateTime();
//loanDataUtil.UpdateLoanInformation(1, loan);
//if (compDataUtil.LoanTimeExceeded().Count > 0)
//{
// foreach (var comp in compDataUtil.LoanTimeExceeded())
// {
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentName);
// }
//}
//List<Component> comps = compDataUtil.GetAllComponents();
//loan = loanDataUtil.GetLoanInformation(comps[0]);
//Console.WriteLine(loan.LoanID + " " + loan.Component);
//loanDataUtil.UpdateLoanInformation(14, loan);
//for (int i = 1; i < compDataUtil.GetAllComponents().Count; i++)
//{
// loanDataUtil.UpdateLoanInformation(i, loan);
//}
////compDataUtil.DeleteComponent(180);
//compDataUtil.LoanTimeExceeded();
//compDataUtil.ComponentReservation("Raspberry Pi Model B 120", 1);
//foreach (var comp in loanDataUtil.GetLoanedComponents())
//{
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentName);
//}
/* Test af udlånt/reserveret komponenter for student ID med X nummer */
//Component newcomp = new Component();
//newcomp.OwnerID = 9;
//compDataUtil.UpdateComponent(1, newcomp);
//Console.WriteLine("------LÅNT-----");
//foreach (var comp in loanDataUtil.GetLoanedComponentFromStudentId("201270749"))
//{
// Console.WriteLine("---------------");
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentNumber + " " + comp.SerieNr + " "
// + comp.ComponentName + " " + comp.ComponentInfo + " " + comp.Category
// + " " + comp.Datasheet + " " + comp.Image);
// Console.WriteLine("---------------");
//}
//Console.WriteLine("---------------");
//Console.WriteLine();
//Console.WriteLine("----RESERVERET----");
//foreach (var comp in loanDataUtil.GetReservedComponentFromStudentId("201270749"))
//{
// Console.WriteLine("---------------");
// Console.WriteLine(comp.ComponentID + " " + comp.ComponentNumber + " " + comp.SerieNr + " "
// + comp.ComponentName + " " + comp.ComponentInfo + " " + comp.Category
// + " " + comp.Datasheet + " " + comp.Image);
// Console.WriteLine("---------------");
//}
//Console.WriteLine("------------------");
//Console.WriteLine("----RESERVERING SLETTET----");
//loanDataUtil.RemoveReservation(1);
/* Test af udlånt/reserveret komponenter for student ID med X nummer */
//var loan = new LoanInformation();
//loan.LoanDate = DateTime.Now;
//loan.ReturnDate = new SqlDateTime(2014, 05, 02);
//for (int i = 1; i <= 3; i++)
// loanDataUtil.UpdateLoanInformation(i, loan);
}
