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