public ActionResult Create([Bind(Include = "account,password,passwordConfirm,salt,last_name,first_name,phone,email,city,town,road,address_number")] Users user)
{
if (ModelState.IsValid)
{
User add = new User();
user.salt = Guid.NewGuid();
string SaltAndPassword = String.Concat(user.salt, user.password);
string EncryptPassword = Encrypt(SaltAndPassword);
user.password = EncryptPassword;
add.account = user.account;
add.address_number = user.address_number;
add.city = user.city;
add.email = user.email;
add.first_name = user.first_name;
add.last_name = user.last_name;
add.password = user.password;
add.phone = user.phone;
add.road = user.road;
add.salt = user.salt;
add.town = user.town;
db.Users.Add(add);
db.SaveChanges();
return(RedirectToAction("Login"));
}
return(View());
}
public ActionResult Edit([Bind(Include = "Id,UserName,Address,Password")] User Euser)
{
if (ModelState.IsValid)
{
db.Entry(Euser).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(Euser));
}
public ActionResult Edit([Bind(Include = "Sponsor_id,Email,Name,Password")] Sponsor sponsor)
{
if (ModelState.IsValid)
{
db.Entry(sponsor).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sponsor));
}
public ActionResult Create([Bind(Include = "column_0,Scientific_Name,Vernacular_name,Event_Date__parsed,Latitude,Longitude")] PestLocation pestLocation)
{
if (ModelState.IsValid)
{
db.PestLocation.Add(pestLocation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(pestLocation));
}
public ActionResult Create([Bind(Include = "id,name,email,phone,address")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
//[Bind(Include = "Id,DictionaryName,SourceLanguage,Path")]
public ActionResult Create(Dictionaries dictionaries)
{
if (ModelState.IsValid)
{
dictionaries.upload(dictionaries);
db.Dictionaries.Add(dictionaries);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dictionaries));
}
public ActionResult AddDoctor([Bind(Include = "Doctor_id,Email,Name,Password,Max_team,Last_login")] Doctor doctor)
{
if (ModelState.IsValid)
{
//db.Doctor.SqlQuery("INSERT INTO Doctor (Last_login) VALUES('@DateTime.Now') ");
//db.SaveChanges();
Doctor doctor1 = new Doctor();
doctor1.Last_login = DateTime.Now;
db.Doctor.Add(doctor);
db.SaveChanges();
return(RedirectToAction("Doctor"));
}
return(View(doctor));
}
public ActionResult ForgotPassword(string Email)
{
//verify Email
//GEnerate Reser Password link
//Send Email
string message = "";
bool status = false;
using (DatabaseEntities1 dc = new DatabaseEntities1())
{
var account = dc.Users.Where(a => a.Email == Email).FirstOrDefault();
if (account != null)
{
//Send reset password email
string resetCode = Guid.NewGuid().ToString();
SendVerificationLinkEmail(account.Email, resetCode, "ResetPassword");
account.ResetPasswordCode = resetCode;
//
//this code wil prevent the website from having issues with password do not match
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "A link to reset your password has been sent to your Email.";
}
else
{
message = "Account not found";
}
}
ViewBag.Message = message;
return(View());
}
public ActionResult ResetPassword(ResetPasswordModel model)
{
var message = "";
if (ModelState.IsValid)
{
using (DatabaseEntities1 dc = new DatabaseEntities1())
{
var user = dc.Users.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault();
if (user != null)
{
user.Password = Crypto.Hash(model.NewPassword);
user.ResetPasswordCode = "";
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "Your password has been successfully updated";
}
}
}
else
{
message = "Something invalid";
}
ViewBag.Message = message;
return(View(model));
}
public ActionResult Save(Korisnikk kor)
{
bool status = false;
if (ModelState.IsValid)
{
using (DatabaseEntities1 dq = new DatabaseEntities1())
{
if (kor.Korisnik_Id > 0)
{
var varr = dq.Korisnikks.Where(a => a.Korisnik_Id == kor.Korisnik_Id).FirstOrDefault();
if (varr != null)
{
varr.FirstName = kor.FirstName;
varr.LastName = kor.LastName;
varr.AdressName = kor.AdressName;
varr.E_mail = kor.E_mail;
varr.Tel_broj = kor.Tel_broj;
varr.Vrsta_tel_broja = kor.Vrsta_tel_broja;
}
}
else
{
dq.Korisnikks.Add(kor);
}
dq.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
// If your activity returns a value, derive from CodeActivity<TResult>
// and return the value from the Execute method.
protected override void Execute(CodeActivityContext context)
{
User user = db.Users.Find(context.GetValue(UserId));
db.Users.Remove(user);
db.SaveChanges();
}
public void AddRecord(string Patente,
string Nombre,
string Apellido,
int Registrador)
{
Db.Record.AddObject(
new Record()
{
FirstName = Nombre,
LastName = Apellido,
Plate = Patente,
IdUser = Registrador,
GateIn = DateTime.Now
}
);
Db.SaveChanges();
}
public ActionResult AddEmployee(Employee emp)
{
var context = new DatabaseEntities1();
context.Employee.Add(emp);
context.SaveChanges();
return(RedirectToAction("Display"));
}
public ActionResult Index(string first, string last, string email, string password, string roll)
{
switch (roll)
{
case "Arrangör":
var nyArrangör = new Arrangörer
{
Firstname = first,
Lastname = last,
Email = email,
Password = password,
Role = roll
};
databas.Arrangörer.Add(nyArrangör);
databas.SaveChanges();
break;
case "Besökare":
var nybesökare = new Besökare
{
Firstname = first,
Lastname = last,
Email = email,
Password = password,
Role = roll
};
databas.Besökare.Add(nybesökare);
databas.SaveChanges();
break;
}
return(RedirectToAction("index"));
}
// If your activity returns a value, derive from CodeActivity<TResult>
// and return the value from the Execute method.
protected override void Execute(CodeActivityContext context)
{
// Obtain the runtime value of the Text input argument
int carId = context.GetValue(this.CarId);
Car car = db.Cars.Find(carId);
db.Cars.Remove(car);
db.SaveChanges();
}
public void ShoppingCart(string isbn)
{
if (Session["User_id"] != null)
{
var list = db.Carts.Select(s => s);
double isbnD = Convert.ToDouble(isbn);
int User_id = Convert.ToInt32(Session["User_id"]);
bool has = list.Any(cus => cus.ISBN == isbnD && cus.User_id == User_id);
if (has)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
db.Carts.Remove(db.Carts.Single(cus => cus.ISBN == isbnD && cus.User_id == User_id));
db.SaveChanges();
}
}
else
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var cart = new Cart()
{
User_id = User_id, ISBN = Convert.ToDouble(isbn), Quantity = 1
};
db.Carts.Add(cart);
db.SaveChanges();
}
}
}
else
{
// UNREGISTERED USER
if (Session["shoppingCart"] == null || Session["shoppingCart"] == "")
{
Session["shoppingCart"] = isbn.ToString();
}
else
{
List <string> isbns = Session["shoppingCart"].ToString().Split(',').ToList();
//Check of die al in je cart zit.
//Deletes product from cart
if (isbns.Contains(isbn))
{
isbns.RemoveAll(s => isbn == s);
var newcart = String.Join(",", isbns);
Session["shoppingCart"] = newcart;
}
else
{
Session["shoppingCart"] = Session["shoppingCart"] + "," + isbn.ToString();
}
}
}
}
public ActionResult DeleteEmployee(string id)
{
int EmpId = int.Parse(id);
var context = new DatabaseEntities1();
var model = context.Employee.FirstOrDefault((e) => e.EmpId == EmpId);
context.Employee.Remove(model);
context.SaveChanges();
return(RedirectToAction("Display"));
}
public ActionResult Confirmation(int orderNumber)
{
Dictionary <Book, int> BookQuantity = new Dictionary <Book, int>();
Tuple <Order, OrderDetail, Payment> info;
using (var db = new DatabaseEntities1())
{
Order orderObj = db.Orders.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
OrderDetail orderDetailObj = db.OrderDetails.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
Payment paymentObj = db.Payments.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
int currentuser_id = Convert.ToInt32(Session["User_id"]);
User currentuser = db.Users.Where(x => x.User_id == currentuser_id).FirstOrDefault();
if (Session["User_id"] != null)
{
string Email = Convert.ToString(currentuser.Email);
SendConEmail(Email, orderNumber);
}
else
{
string Email = Convert.ToString(orderDetailObj.Email);
SendConEmail(Email, orderNumber);
}
// GET PRODUCTS
string[] products = orderDetailObj.Products.Split('|');
foreach (var item in products)
{
string[] books = item.Split('-');
double isbn = Convert.ToDouble(books[0]);
Book book = db.Books.Where(x => x.ISBN == isbn).FirstOrDefault();
int quantity = Convert.ToInt32(books[1]);
BookQuantity.Add(book, quantity);
}
info = new Tuple <Order, OrderDetail, Payment>(orderObj, orderDetailObj, paymentObj);
Session["Checkout"] = BookQuantity;
// CLEAR CARTS
if (Session["User_id"] != null)
{
int User_id = Convert.ToInt32(Session["User_id"]);
db.Carts.RemoveRange(db.Carts.Where(x => x.User_id == User_id));
db.SaveChanges();
}
else
{
Session["ShoppingCart"] = null;
}
}
return(View(info));
}
public ActionResult Find(Employee emp)
{
var context = new DatabaseEntities1();
var model = context.Employee.FirstOrDefault((e) => e.EmpId == emp.EmpId);
model.EmpName = emp.EmpName;
model.EmpAddress = emp.EmpAddress;
model.EmpSalary = emp.EmpSalary;
context.SaveChanges();
return(RedirectToAction("Display"));
}
public ActionResult Authorize(User userModel)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var userPassword = Crypto.Hash(userModel.Password);
var userData = db.Users.Where(x => x.Email == userModel.Email &&
x.Password == userPassword).FirstOrDefault();
if (userData == null)
{
userModel.LoginErrorMessage = "Wrong Email or Password";
return(View("Index", userModel));
}
else if (userData.IsEmailVerified == false)
{
userModel.LoginErrorMessage = "Your email must be verified before you can log in. A new verification link has been sent to your email ";
SendVerificationLinkEmail(userData.Email, userData.ActivationCode.ToString());
return(View("Index", userModel));
}
else
{
//SUCCESFULLY LOGIN
Session["User_id"] = userData.User_id;
Session["Name"] = userData.Name;
var cart = (Dictionary <Book, int>)Session["Cart"];
db.Carts.RemoveRange(db.Carts.Where(x => x.User_id == userData.User_id));
db.SaveChanges();
foreach (KeyValuePair <Book, int> kv in cart)
{
var cartObj = new Cart()
{
User_id = userData.User_id, ISBN = kv.Key.ISBN, Quantity = kv.Value
};
db.Carts.Add(cartObj);
db.SaveChanges();
}
return(RedirectToAction("Address", "Checkout"));
}
}
}
public ActionResult Edit([Bind(Include = "Name,Price,Description,Image ")] Meal meal, HttpPostedFileBase imgFile)
{
string path = "";
if (imgFile.FileName.Length > 0)
{
path = "~/pics/" + Path.GetFileName(imgFile.FileName);
imgFile.SaveAs(Server.MapPath(path));
}
meal.Image = path;
//var before = db.Meals.AsNoTracking().Where(x => x.MealId == meal.MealId).ToList().FirstOrDefault();
//meal.Name = before.Name;
//meal.Price = before.Price;
//meal.Description= before.Description;
db.Entry(meal).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
// If your activity returns a value, derive from CodeActivity<TResult>
// and return the value from the Execute method.
protected override void Execute(CodeActivityContext context)
{
UserRequest userReq = context.GetValue(this.UserReq);
User user = new User();
user.FirstName = userReq.FirstName;
user.LastName = userReq.LastName;
user.CarId = userReq.CarId;
User createdUser = db.Users.Add(user);
db.SaveChanges();
CreatedUserId.Set(context, createdUser.Id);
}
// If your activity returns a value, derive from CodeActivity<TResult>
// and return the value from the Execute method.
protected override void Execute(CodeActivityContext context)
{
// Obtain the runtime value of the Text input argument
CarRequest carRequest = context.GetValue(this.CarReq);
Car car = new Car();
car.Id = carRequest.Id;
car.Name = carRequest.Name;
car.Type = carRequest.Type;
car.Year = carRequest.Year;
Car createdCar = db.Cars.Add(car);
db.SaveChanges();
CreatedCarId.Set(context, createdCar.Id);
}
// POST: api/visitor (En post request till denna ända lägger till användare)
public int?Post([FromBody] Besökare nybesökare)
{
if (nybesökare.Firstname == null || nybesökare.Lastname == null || nybesökare.Role == null)
{
return(null);
}
if (nybesökare.Role != "Besökare")
{
nybesökare.Role = "Besökare";
}
databas.Besökare.Add(nybesökare);
databas.SaveChanges();
return(nybesökare.Id);
}
public ActionResult AddOrEdit(User userModel)
{
using (DatabaseEntities1 dbModel = new DatabaseEntities1())
{
if (dbModel.Users.Any(x => x.UserName == userModel.UserName))
{
ViewBag.DuplicateMessage = "Username already exist.";
return(View("AddOrEdit", userModel));
}
dbModel.Users.Add(userModel);
dbModel.SaveChanges();
}
ModelState.Clear();
ViewBag.SuccessMessage = "Registration Successful.";
return(View("AddOrEdit", new User()));
}
// POST: api/Organizer (En post request till denna ända lägger till användare)
public string Post([FromBody] Arrangörer arrangör)
{
if (arrangör.Firstname == null || arrangör.Lastname == null || arrangör.Role == null)
{
return(null);
}
if (arrangör.Role != "Arrangör")
{
arrangör.Role = "Arrangör";
}
databas.Arrangörer.Add(arrangör);
databas.SaveChanges();
return("Successfully added new organizer!");
}
public ActionResult DeleteKorisnik(int id)
{
bool status = false;
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var v = db.Korisnikks.Where(a => a.Korisnik_Id == id).FirstOrDefault();
if (v != null)
{
db.Korisnikks.Remove(v);
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public void FavoriteList(string isbn)
{
if (Session["User_id"] == null)
{
TempData["favo"] = "<script>alert('You need to login first.');</script>";
}
else
{
var list = db.Favorites.Select(s => s);
double isbnD = Convert.ToDouble(isbn);
int User_id = Convert.ToInt32(Session["User_id"]);
bool has = list.Any(cus => cus.ISBN == isbnD && cus.User_id == User_id);
//CHECKEN OF ISBN AL IN FAVORIETEN ZIT VAN DE GEBRUIKER.
if (has)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
db.Favorites.Remove(db.Favorites.Single(cus => cus.ISBN == isbnD && cus.User_id == User_id));
db.SaveChanges();
}
}
else
{
// ISBN TOEVOEGEN AAN FAVORIETEN
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var favo = new Favorite()
{
User_id = User_id, ISBN = Convert.ToDouble(isbn)
};
db.Favorites.Add(favo);
db.SaveChanges();
}
}
}
}
public ActionResult VerifyAccount(string id)
{
bool status = false;
using (DatabaseEntities1 dc = new DatabaseEntities1())
{
dc.Configuration.ValidateOnSaveEnabled = false; //This line will avoid any problems by confirm password
//does not match issue in the save changes section
var v = dc.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault();
if (v != null)
{
v.IsEmailVerified = true;
dc.SaveChanges();
status = true;
}
else
{
ViewBag.Message = "Invaild Request";
}
}
ViewBag.Status = status;
return(View());
}
public static int insertProduct(Product newProduct)
{
de.Products.Add(newProduct);
return(de.SaveChanges());
}
