public Startup(IConfiguration configuration)
{
Configuration = configuration;
using (var client = new PlanContext())
{
client.Database.EnsureCreated();
try
{
Rodzaj_uzytkownika rodzaj_Uzytkownika = new Rodzaj_uzytkownika();
rodzaj_Uzytkownika.rodzajuzytkownikaId = 1;
rodzaj_Uzytkownika.rodzajuzytkownika = "Admin";
client.Rodzaj_uzytkownika.Add(rodzaj_Uzytkownika);
client.SaveChanges();
Uzytkownik uzytkownik = new Uzytkownik();
uzytkownik.rodzajuzytkownikaId = 1;
uzytkownik.login = "******";
uzytkownik.haslo = "1234";
uzytkownik.rodzajuzytkownikaId = 1;
client.Uzytkownik.Add(uzytkownik);
client.SaveChanges();
}
catch (Exception) { }
}
}
public ActionResult Create(Plan plan)
{
if (ModelState.IsValid)
{
db.Plans.Add(plan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(plan));
}
public ActionResult Create([Bind(Include = "Id,Note,Date")] Plan plan)
{
if (ModelState.IsValid)
{
db.Plans.Add(plan);
db.SaveChanges();
return(RedirectToAction("AllNote"));
}
return(View(plan));
}
public ActionResult Create(Plan model)
{
Plan plan = new Plan
{
Title = model.Title,
Description = model.Description,
Date = model.Date,
Img = model.Img,
IsPriority = false
};
_context.Plans.Add(plan);
_context.SaveChanges();
return(RedirectToAction("ListPlans"));
}
public IActionResult RegisterUser(RegUser newRegUser)
{
if (ModelState.IsValid)
{
User current = _context.Users.SingleOrDefault(e => e.Email == newRegUser.Email);
if (current != null)
{
ModelState.AddModelError("Email", "Email already exists!");
return(View("Index"));
}
else
{
PasswordHasher <RegUser> Hasher = new PasswordHasher <RegUser>();
string hashed = Hasher.HashPassword(newRegUser, newRegUser.Password);
User user = new User // Creating a new User using the info provided by the user via the form
{
FirstName = newRegUser.FirstName,
LastName = newRegUser.LastName,
Email = newRegUser.Email,
Password = hashed,
};
_context.Add(user);
_context.SaveChanges();
User sessionuser = _context.Users.Where(u => u.Email == newRegUser.Email).SingleOrDefault();
HttpContext.Session.SetInt32("userID", sessionuser.UserId);
HttpContext.Session.SetString("firstname", sessionuser.FirstName);
return(RedirectToAction("Dash"));
}
}
else
{
return(View("Index"));
}
}
public IActionResult RegisterUser(RegUser newRegUser) // This Method takes in a parameter of newRegUser
{
if (ModelState.IsValid) // There are NO errors
{
User current = _context.Users.SingleOrDefault(e => e.Email == newRegUser.Email); // Query to check if there is an existing email
if (current != null) // If the results come up with something...
{
ModelState.AddModelError("Email", "Email already exists!"); // ...An email exists and renders the Index View
// This is an example of another way to add errors without using ViewBag
// The parameters: ModelState.AddModelError("The attribute NAME on the form where you want to put it", "Error Message");
return(View("Index"));
}
else // If email does not exist in the database yet...
{
PasswordHasher <RegUser> Hasher = new PasswordHasher <RegUser>(); // This will hash the password
string hashed = Hasher.HashPassword(newRegUser, newRegUser.Password); // This will take in the user's given password and hash it
User user = new User // Creating a new User using the info provided by the user via the form
{
FirstName = newRegUser.FirstName,
LastName = newRegUser.LastName,
Email = newRegUser.Email,
Password = hashed,
};
_context.Add(user); // Instant Query to ADD!
_context.SaveChanges(); // Query to Save Changes
User sessionuser = _context.Users.Where(u => u.Email == newRegUser.Email).SingleOrDefault(); // Model User has a variable sessionuser that contains the query of getting the new user's email to gain access to their other info
HttpContext.Session.SetInt32("userID", sessionuser.UserId); // Setting userID to hold onto the user's UserId while in session
HttpContext.Session.SetString("firstname", sessionuser.FirstName); // Setting firstname to hold th user's FirstName while in session
return(RedirectToAction("Dash")); // Goes to the Method named Dash
}
}
else // If there ARE errors present...
{
return(View("Index")); // ...Go back to the Index view
// When you want to show errors, DO NOT Redirect!
}
}
public PlanViewModels(PlanType type, List <DateTime> dates)
{
if (dates == null)
{
return;
}
this.type = type;
this.dates = dates;
db = new PlanContext();
switch (type)
{
case PlanType.ГГПЗ:
db.PlanGGPZ.Load();
{
List <PlanGGPZ> planDatas = db.PlanGGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
foreach (DateTime dateTime in dates)
{
if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime))
{
db.PlanGGPZ.Add(new PlanGGPZ()
{
Date = dateTime.ToLongDateString()
});
}
}
}
db.SaveChanges();
PlanGGPZ = db.PlanGGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
break;
case PlanType.НГП:
db.PlanNGP.Load();
{
List <PlanNGP> planDatas = db.PlanNGP.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
foreach (DateTime dateTime in dates)
{
if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime))
{
db.PlanNGP.Add(new PlanNGP()
{
Date = dateTime.ToLongDateString()
});
}
}
}
db.SaveChanges();
PlanNGP = db.PlanNGP.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
break;
case PlanType.ЮПГПЗ:
db.PlanYPGPZ.Load();
{
List <PlanYPGPZ> planDatas = db.PlanYPGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
foreach (DateTime dateTime in dates)
{
if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime))
{
db.PlanYPGPZ.Add(new PlanYPGPZ()
{
Date = dateTime.ToLongDateString()
});
}
}
}
db.SaveChanges();
PlanYPGPZ = db.PlanYPGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
break;
case PlanType.ЮБГПЗ:
db.PlanYBGPZ.Load();
{
List <PlanYBGPZ> planDatas = db.PlanYBGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
foreach (DateTime dateTime in dates)
{
if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime))
{
db.PlanYBGPZ.Add(new PlanYBGPZ()
{
Date = dateTime.ToLongDateString()
});
}
}
}
db.SaveChanges();
PlanYBGPZ = db.PlanYBGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
break;
case PlanType.МГПЗ:
db.PlanMGPZ.Load();
{
List <PlanMGPZ> planDatas = db.PlanMGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
foreach (DateTime dateTime in dates)
{
if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime))
{
db.PlanMGPZ.Add(new PlanMGPZ()
{
Date = dateTime.ToLongDateString()
});
}
}
}
db.SaveChanges();
PlanMGPZ = db.PlanMGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
break;
case PlanType.ВГПЗ:
db.PlanVGPZ.Load();
{
List <PlanVGPZ> planDatas = db.PlanVGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
foreach (DateTime dateTime in dates)
{
if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime))
{
db.PlanVGPZ.Add(new PlanVGPZ()
{
Date = dateTime.ToLongDateString()
});
}
}
}
db.SaveChanges();
PlanVGPZ = db.PlanVGPZ.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
break;
case PlanType.НВГПК:
db.PlanNVGPK.Load();
{
List <PlanNVGPK> planDatas = db.PlanNVGPK.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
foreach (DateTime dateTime in dates)
{
if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime))
{
db.PlanNVGPK.Add(new PlanNVGPK()
{
Date = dateTime.ToLongDateString()
});
}
}
}
db.SaveChanges();
PlanNVGPK = db.PlanNVGPK.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
break;
case PlanType.БГПК:
db.PlanBGPK.Load();
{
List <PlanBGPK> planDatas = db.PlanBGPK.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
foreach (DateTime dateTime in dates)
{
if (!planDatas.Any(x => DateTime.Parse(x.Date) == dateTime))
{
db.PlanBGPK.Add(new PlanBGPK()
{
Date = dateTime.ToLongDateString()
});
}
}
}
db.SaveChanges();
PlanBGPK = db.PlanBGPK.Local.ToBindingList().Where(x => Between(DateTime.Parse(x.Date), dates.First(), dates.Last())).ToList();
break;
}
}
