internal void CreateNewStatistic()
{
Statistic statistics = new Statistic
{
Year = DateTime.UtcNow.Year,
Month = DateTime.UtcNow.Month,
Day = DateTime.UtcNow.Day,
Hour = DateTime.UtcNow.Hour,
IdSession = HttpContext.Current.Session.SessionID
};
using (DHDomoticaDBEntities DHDomoticadbModel = new DHDomoticaDBEntities())
{
if (DHDomoticadbModel.Statistics.FirstOrDefault(x => x.IdSession == IdSession) == null)
{
DHDomoticadbModel.Statistics.Add(statistics);
DHDomoticadbModel.SaveChanges();
}
}
}
//Aanpassen aan CRUD. Cookies eruit.
internal void EditExistingUser(int ID)
{
// var con = System.Web.HttpContext.Current.Request.Cookies;
using (DHDomoticaDBEntities DHDomoticadbModel = new DHDomoticaDBEntities())
{
User user = DHDomoticadbModel.Users.FirstOrDefault(x => x.ID == ID);
{
user.Password = Password;
user.AdminID = AdminID;
user.FirstName = FirstName;
user.LastName = LastName;
user.Gender = Gender;
user.Country = Country;
user.Province = Province;
user.City = City;
user.ZipCode = ZipCode;
user.BillingAddress = BillingAddress;
};
{
DHDomoticadbModel.SaveChanges();
}
}
}
internal void ChangeExistingUser()
{
var con = System.Web.HttpContext.Current.Request.Cookies;
var idCheck = Convert.ToInt32(con["UserID"].Value);
using (DHDomoticaDBEntities DHDomoticadbModel = new DHDomoticaDBEntities())
{
User user = DHDomoticadbModel.Users.FirstOrDefault(x => x.ID == idCheck);
{
user.FirstName = FirstName;
user.LastName = LastName;
user.Gender = Gender;
user.EMail = EMail;
user.Country = Country;
user.Province = Province;
user.City = City;
user.ZipCode = ZipCode;
user.BillingAddress = BillingAddress;
};
{
DHDomoticadbModel.SaveChanges();
}
}
}
private Payment CreatePayment(APIContext apiContext, string redirectUrl)
{
var listItems = new ItemList()
{
items = new List <Item>()
};
List <ItemModel> Order = (List <ItemModel>)Session["cart"];
int totaal = 0;
foreach (var item in Order)
{
int prijs = Convert.ToInt16(Math.Round(item.Product.Price));
listItems.items.Add(new Item()
{
name = item.Product.Name,
currency = "EUR",
price = prijs.ToString(),
quantity = item.Quantity.ToString(),
sku = "sku"
});
totaal += prijs * item.Quantity;
using (DHDomoticaDBEntities DHDomoticadbModel = new DHDomoticaDBEntities())
{
var stock = DHDomoticadbModel.Products.FirstOrDefault(x => x.ID == item.Product.ID).Stock;
Session["stock"] = stock - item.Quantity;
DHDomoticadbModel.Products.FirstOrDefault(x => x.ID == item.Product.ID).Stock = stock - item.Quantity;
DHDomoticadbModel.SaveChanges();
}
Session["Totaal"] = totaal;
}
var payer = new Payer()
{
payment_method = "paypal"
};
var redirUrls = new RedirectUrls()
{
cancel_url = redirectUrl,
return_url = redirectUrl
};
var details = new Details()
{
tax = "0",
shipping = "0",
subtotal = Order.Sum(item => Convert.ToInt16(Math.Round(item.Product.Price)) * item.Quantity).ToString()
};
var amount = new Amount()
{
currency = "EUR",
total = (Convert.ToDouble(details.tax) + Convert.ToDouble(details.shipping) + Convert.ToDouble(details.subtotal)).ToString(),
details = details
};
var transactionList = new List <Transaction>();
transactionList.Add(new Transaction()
{
description = "Testing Transaction",
invoice_number = Convert.ToString((new Random()).Next(100000)),
amount = amount,
item_list = listItems
});
payment = new Payment()
{
intent = "sale",
payer = payer,
transactions = transactionList,
redirect_urls = redirUrls
};
return(payment.Create(apiContext));
}
public ActionResult SignInPage(SignUpViewModel userModel)
{
var cookieExpDate = DateTime.UtcNow.AddDays(2);
using (DHDomoticaDBEntities DHDomoticadbModel = new DHDomoticaDBEntities())
{
if (userModel.Password == null || userModel.EMail == null)
{
//geen geldige credentials ingevoerd (missend wachtwoord OF missend EmailAddress)
return(View("SignInPage", new SignUpViewModel()));
}
else
{
var ePwd = Crypto.Hash(userModel.Password);
var x = DHDomoticadbModel.Users.FirstOrDefault(u => u.EMail == userModel.EMail && u.Password == ePwd);
if (x == null)
{
//geen geldige credentials ingevoerd (geen combinatie van email + ww)
return(View("SignInPage", new SignUpViewModel()));
}
else
{
if (x != null) //Moet aan de checkbox worden verbonden. als deze niet gecheckt is komt hij in het bovenste, zowel dan in het onderste
{
if (!x.EmailConfirmed.Value)
{
ViewBag.Message = "U moet eerst uw emailadres bevestigen.";
return(View("SignInPage", new SignUpViewModel()));
}
//Geldige credentials ingevoerd
//Create Cookie
HttpCookie UserCookie = new HttpCookie("UserEMail", x.EMail);
HttpCookie PwCookie = new HttpCookie("UserPw", x.Password);
HttpCookie NameCookie = new HttpCookie("UserName", x.FirstName);
HttpCookie LastNameCookie = new HttpCookie("UserLast", x.LastName);
HttpCookie IDCookie = new HttpCookie("UserID", x.ID.ToString());
//HttpCookie UserNameCookie = new HttpCookie("UserName", userModel.FirstName.ToString());
//Expire Date of made cookie
UserCookie.Expires = cookieExpDate;
PwCookie.Expires = cookieExpDate;
NameCookie.Expires = cookieExpDate;
LastNameCookie.Expires = cookieExpDate;
IDCookie.Expires = cookieExpDate;
//Save data at Cookies
HttpContext.Response.SetCookie(UserCookie);
HttpContext.Response.SetCookie(PwCookie);
HttpContext.Response.SetCookie(NameCookie);
HttpContext.Response.SetCookie(LastNameCookie);
HttpContext.Response.SetCookie(IDCookie);
//Returns to index page
return(RedirectToAction("Index", "Home"));
}
else
{
//Geldige credentials ingevoerd (en de checkbox aangevinkt)
//Create Cookie
HttpCookie UserCookie = new HttpCookie("UserEMail", x.EMail);
HttpCookie PwCookie = new HttpCookie("UserPw", x.Password);
HttpCookie NameCookie = new HttpCookie("UserName", x.FirstName);
HttpCookie LastNameCookie = new HttpCookie("UserLast", x.LastName);
HttpCookie IDCookie = new HttpCookie("UserID", x.ID.ToString());
//Save data at Cookies
HttpContext.Response.SetCookie(UserCookie);
HttpContext.Response.SetCookie(PwCookie);
HttpContext.Response.SetCookie(NameCookie);
HttpContext.Response.SetCookie(LastNameCookie);
HttpContext.Response.SetCookie(IDCookie);
//Returns to index page
return(RedirectToAction("Index", "Home"));
}
}
}
}
}
public HomeController()
{
_context = new DHDomoticaDBEntities();
}
public ActionResult Index(string caseSwitch)
{
//Zet de jaar, maand en dag op de komende huidige dag
var year = DateTime.UtcNow.Day;
var month = DateTime.UtcNow.Month;
var day = DateTime.UtcNow.Year;
var number = 0;
List <DataPoint> MonthlyVisitors = new List <DataPoint>();
int tabel = 0;
int increments = 0;
//string caseSwitch = "1 maand";
switch (caseSwitch)
{
case "Afgelopen Week":
tabel = 7;
increments = 1;
break;
case "Afgelopen Maand":
tabel = 30;
increments = 1;
break;
case "Afgelopen 3 Maanden":
tabel = 90;
increments = 1;
break;
case "Afgelopen Jaar":
tabel = 365;
increments = 1;
break;
}
// De forloop zorgt ervoor dat er 30 dagen worden gecontroleerd in de database en deze in de array zetten om een plaatje ervan te maken
for (int i = tabel; i >= 0; i = i - increments)
{
var test = DateTime.UtcNow.AddDays(-i);
year = test.Year;
month = test.Month;
day = test.Day;
string stringDay = test.Day.ToString();
string stringMonth = test.ToString("MMM");
using (DHDomoticaDBEntities DHDomoticadbModel = new DHDomoticaDBEntities())
{
var hello = DHDomoticadbModel.Statistics.Where(z => z.Month == month && z.Year == year && z.Day == day).ToArray();
number = hello.Length;
DHDomoticadbModel.SaveChanges();
}
MonthlyVisitors.Add(new DataPoint(stringDay + " " + stringMonth, number));
}
ViewBag.MonthlyVisitors = JsonConvert.SerializeObject(MonthlyVisitors);
ShowAdminSidebar();
return(View());
}
