public Customer Update(Customer updatedType) { DBCustomer dBCustomer = mapperCustomer.Map(updatedType, context); context.SaveChanges(); return(mapperCustomer.Map(dBCustomer)); }
public void CreateOrder(Customer customer, Cart cart) { var db = new DB(); DBCustomer dBCustomer = db.Customers.Find(customer.ID); Order order = new Order { DateCreated = DateTime.Now, Customer = dBCustomer }; db.Order.Add(order); foreach (CartItem cartItem in cart.CartItem) { Movie movie = db.Movie.Find(cartItem.Movie.ID); OrderLine orderLine = new OrderLine { Order = order, Movie = movie, Price = cartItem.Price }; db.OrderLine.Add(orderLine); } db.SaveChanges(); }
public ActionResult Register(Customer newUser, String password_confirmation) { if (ModelState.IsValid) { if (!newUser.password.Equals(password_confirmation)) { ViewBag.confirmation = true; return View(); } var customerDB = new DBCustomer(); if (!customerDB.checkEmail(newUser.email,null)) { ViewBag.email = true; return View(); } else { byte[] hashedPassword = makeHash(newUser.password); bool insertOK = customerDB.add(newUser, hashedPassword); if (insertOK) { logInUser(newUser.email); return RedirectToAction("PersonalSite"); } } } return View(); }
public ActionResult Register(Customer newUser, String password_confirmation) { if (ModelState.IsValid) { if (!newUser.password.Equals(password_confirmation)) { ViewBag.confirmation = true; return(View()); } var customerDB = new DBCustomer(); if (!customerDB.checkEmail(newUser.email, null)) { ViewBag.email = true; return(View()); } else { byte[] hashedPassword = makeHash(newUser.password); bool insertOK = customerDB.add(newUser, hashedPassword); if (insertOK) { logInUser(newUser.email); return(RedirectToAction("PersonalSite")); } } } return(View()); }
public bool checkIfBought(int movieId, string username) { IQueryable <movieCustomer> aMovieCustomer = db.Order.Join(db.LineItem, o => o.Id, li => li.Order.Id, (o, li) => new movieCustomer { CustomerId = o.Customer.Id, MovieId = li.Movie.Id }) .Where(x => x.MovieId == movieId); DBCustomer Customer = db.DBCustomer.Where(k => k.Username == username).FirstOrDefault(); foreach (var i in aMovieCustomer) { //System.Diagnostics.Debug.Write(" CustomerID: " + i.CustomerId + " MovieID: " + i.MovieId); if (i.CustomerId.Equals(Customer.Id)) { return(true); } } return(false); }
public int CreateCustomer(string ScrName, string Username, string Password, string Email, DateTime DateOfCreation) { DBCustomer dbc = new DBCustomer(); Console.WriteLine(); Console.WriteLine("CreateCustomer() " + GetExecutionThreadTime()); return(dbc.CreateCustomer(ScrName, Username, Password, Email, DateOfCreation)); }
public string[] isFriend(string Username) { DBCustomer dbc = new DBCustomer(); Console.WriteLine(); Console.WriteLine("isFriend() " + GetExecutionThreadTime()); return(dbc.isFriend(Username)); }
public void UpdateCustomer(string ScrName, string Username, string Password, string Salt, string Email) { DBCustomer dbc = new DBCustomer(); Console.WriteLine(); Console.WriteLine("UpdateCustomer() " + GetExecutionThreadTime()); dbc.UpdateCustomer(ScrName, Username, Password, Salt, Email); }
public void DeleteCustomer(string Username) { DBCustomer dbc = new DBCustomer(); Console.WriteLine(); Console.WriteLine("DeleteCustomer() " + GetExecutionThreadTime()); dbc.DeleteCustomer(Username); }
public int Login(string Username, string Password) { DBCustomer dbc = new DBCustomer(); Console.WriteLine(); Console.WriteLine("Login() " + GetExecutionThreadTime()); return(dbc.Login(Username, Password)); }
public DataSet ProfileView(string Username) { DBCustomer dbc = new DBCustomer(); DataSet ds = dbc.ProfileViev(Username); Console.WriteLine(); Console.WriteLine("ProfileView() " + GetExecutionThreadTime()); return(ds); }
public DataSet Highscore() { DBCustomer dbc = new DBCustomer(); DataSet ds = dbc.Highscore(); Console.WriteLine(); Console.WriteLine("Highscore() " + GetExecutionThreadTime()); return(ds); }
public void Remove(Customer genericType) { DBCustomer customer = context.DBCustomers.ToList().Find(customer => customer.Name.Equals(genericType.Name)); if (customer is not null) { context.DBCustomers.Remove(customer); context.SaveChanges(); } }
public void update(Customer existingType, Customer updatedType) { DBCustomer customer = context.DBCustomers.ToList().Find(customer => customer.Name.Equals(existingType.Name)); if (customer is not null) { customer.Name = updatedType.Name; context.SaveChanges(); } }
public void Remove(int id) { DBCustomer customer = context.DBCustomers.FirstOrDefault(customer => customer.ID == id); if (customer is not null) { context.DBCustomers.Remove(customer); context.SaveChanges(); } }
static void AssignCustomerRequest(FIFakeContext context, DBCustomer customer, bool giveDelay) { //First pick which i have.. List <DBItem> myItems = null; myItems = context.dbContext.GetList <DBItem>() .Where(x => x.count > 0) .Where(x => { var single = context.staticData.GetByID <GDItemData>(x.itemID); return(single.type.IsFlagSet(GDItemDataType.CustomerEat) == true); }).ToList(); if (myItems.Count <= 0) { //Doesnt have anything.. request for that I can make. var listOfAvailable = context.staticData.GetList <GDItemData>() .Where(x => { if (x.type.IsFlagSet(GDItemDataType.CustomerEat) && x.baseLv <= context.easy.UserInfo.userLv) { return(true); } return(false); }).ToList(); if (listOfAvailable.Count <= 0) { throw new FIException(FIErr.Customer_NeedUserCanMakeAtLeastOne); } int randNum = UnityEngine.Random.Range(0, listOfAvailable.Count); customer.itemID = listOfAvailable[randNum].id; customer.itemCnt = UnityEngine.Random.Range(1, 3 + 1); } else { //I have something that i can request!. int randNum = UnityEngine.Random.Range(0, myItems.Count); customer.itemID = myItems[randNum].itemID; int reqCnt = (myItems[randNum].count / 3); if (reqCnt <= 0) { reqCnt = 1; } customer.itemCnt = reqCnt; } if (giveDelay == false) { customer.waitStartedTime = CurrentTime - context.easy.GlobalInfo.customerRegenTime; } else { customer.waitStartedTime = CurrentTime; } }
public void getOrders(int Id) { DBCustomer customer = db.DBCustomer.Find(Id); var orders = customer.Order; foreach (var i in orders) { System.Diagnostics.Debug.Write(Id + " OrderIDs: " + i.Id); foreach (var e in i.LineItem) { System.Diagnostics.Debug.Write(" Ordre nr " + i.Id + " LineItem " + e.Id + " inneholder dienne filmen " + e.Movie.Id); } } }
public bool deleteUser(int id) { var db = new DB(); try { DBCustomer deleteUser = db.Customers.Find(id); db.Customers.Remove(deleteUser); db.SaveChanges(); return(true); } catch { return(false); } }
public Stream ProfileViewJson(string Username) { DBCustomer dbc = new DBCustomer(); DataSet ds = dbc.ProfileViev(Username); string jsonString = string.Empty; jsonString = JsonConvert.SerializeObject(ds); Console.WriteLine(); Console.WriteLine("ProfileViewJson() " + GetExecutionThreadTime()); WebOperationContext.Current.OutgoingResponse.ContentType = "application/json; charset=utf-8"; return(new MemoryStream(Encoding.UTF8.GetBytes(jsonString))); }
public ActionResult LogIn(String un, String pw) { var customerDB = new DBCustomer(); var hashedPassword = makeHash(pw); if (customerDB.validate(un, hashedPassword)) { logInUser(un); return(Json(true)); } else { Session["loggedInUser"] = null; return(Json(false)); } }
public ActionResult LogIn(String un, String pw) { var customerDB = new DBCustomer(); var hashedPassword = makeHash(pw); if (customerDB.validate(un, hashedPassword)) { logInUser(un); return Json(true); } else { Session["loggedInUser"] = null; return Json(false); } }
//To check whether the user exists, and if so, if the credentials are correct public static bool User_in_DB(LoginCustomer User) { using (var db = new DatabaseContext()) { DBCustomer foundUser = db.DBCustomer.FirstOrDefault(b => b.Username == User.Username); if (foundUser != null) { byte[] testPassword = CreateHash(User.Password, foundUser.Salt); bool correctUser = foundUser.Password.SequenceEqual(testPassword); return(correctUser); } else { return(false); } } }
public static DBCustomer RegisterImplementation(Customer inCustomer) { DatabaseContext db = new DatabaseContext(); var newUser = new DBCustomer(); byte[] salt = CreateSalt(); byte[] hash = CreateHash(inCustomer.Password, salt); newUser.Password = hash; newUser.FirstName = inCustomer.FirstName; newUser.LastName = inCustomer.LastName; newUser.Address = inCustomer.Address; newUser.PhoneNumber = inCustomer.PhoneNumber; newUser.Username = inCustomer.Username; newUser.Email = inCustomer.Email; newUser.Salt = salt; PostalCode foundPost = db.PostalCodes.Find(inCustomer.ZipCode); if (foundPost == null) { // Create PostLocation var newPost = new PostalCode { ZipCode = inCustomer.ZipCode, Location = inCustomer.Location }; newUser.PostalCode = newPost; } else { newUser.PostalCode = foundPost; } try { // Add it to the new customer db.DBCustomer.Add(newUser); db.SaveChanges(); } catch (Exception ex) { System.Diagnostics.Debug.Write("Exception!" + ex); } return(newUser); }
public void newOrder(List <Movie> shoppedMovies, string Username) { var newLineItems = new List <LineItem>(); foreach (Movie i in shoppedMovies) { var dbMovie = db.Movie.Find(i.Id); var lineItem = new LineItem() { Movie = dbMovie }; newLineItems.Add(lineItem); } DateTime currentDate = DateTime.Today; var currentDateString = currentDate.ToShortDateString(); var newOrder = new Order() { Dato = currentDateString, LineItem = newLineItems, }; DBCustomer Customer = db.DBCustomer.Where(k => k.Username == Username).FirstOrDefault(); if (Customer.Order.Equals(null)) { var newOrderList = new List <Order>(); newOrderList.Add(newOrder); Customer.Order = newOrderList; } else { Customer.Order.Add(newOrder); } try { db.SaveChanges(); } catch (Exception ex) { System.Diagnostics.Debug.Write("Exception!" + ex); } }
public ActionResult updateUserPassword(String op, String np, String bp) { if (Session["loggedInUser"] == null) { return(RedirectToAction("Frontpage", "Home")); } if (ModelState.IsValid) { Customer c = (Customer)Session["loggedInUser"]; byte[] hpass = makeHash(op); if (Enumerable.SequenceEqual(c.hashpassword, hpass)) { if (np.Equals(bp)) { byte[] hashedPassword = makeHash(np); c.hashpassword = hashedPassword; var customerDB = new DBCustomer(); bool updateOK = customerDB.updatePw(c.id, hashedPassword); if (updateOK) { Session["loggedInUser"] = c; TempData["changed"] = "Passord ble endret"; return(RedirectToAction("PersonalSite")); } else { ViewBag.correct = "klarte ikke oppdatere"; return(View()); } } ViewBag.correct = "bekreftet ikke passordet riktig"; return(View()); } ViewBag.correct = "ikke riktig nåværende passord"; return(View()); } return(RedirectToAction("PersonalSite")); }
private void logInUser(String un) { var customerDB = new DBCustomer(); var founduser = customerDB.findCustomer(un); if (int.Parse(founduser.postalcode) < 1000) { founduser.postalcode = "0" + founduser.postalcode; if (int.Parse(founduser.postalcode) < 100) { founduser.postalcode = "0" + founduser.postalcode; if (int.Parse(founduser.postalcode) < 10) { founduser.postalcode = "0" + founduser.postalcode; } } } founduser.shoppingcart = new ShoppingCart(founduser.id); Session["loggedInUser"] = founduser; }
public bool editUser(int id, Customer editModel) { var db = new DB(); try { DBCustomer editCustomer = db.Customers.Find(id); editCustomer.Username = editModel.Username; editCustomer.Name = editModel.Name; editCustomer.Surname = editModel.Surname; editCustomer.Phone = editModel.Phone; editCustomer.Email = editModel.Email; editCustomer.Admin = editModel.Admin; db.SaveChanges(); return(true); } catch { return(false); } }
public ActionResult updateUserinfo(Customer newUser) { if (ModelState.IsValid) { Customer c = (Customer)Session["loggedInUser"]; var customerDB = new DBCustomer(); if (!customerDB.checkEmail(newUser.email, c.id)) { ViewBag.ok = "email er i bruk av annen bruker, velg en annen"; return(View()); } c.firstname = newUser.firstname; c.lastname = newUser.lastname; c.email = newUser.email; c.phonenumber = newUser.phonenumber; c.address = newUser.address; c.postalcode = newUser.postalcode; c.postalarea = newUser.postalarea; bool updateOK = customerDB.update(c.id, c); if (updateOK) { Session["loggedInUser"] = c; TempData["changed"] = "Brukerinformasjon ble oppdatert"; return(RedirectToAction("PersonalSite")); } else { Customer old = (Customer)Session["loggedInUser"]; ViewBag.ok = "klarte ikke oppdatere"; return(View()); } } ViewBag.ok = "et felt er blankt, fyll det ut og trykk oppdater"; return(View()); }
public bool addCustomer(Customer customerModel) { var db = new DB(); byte[] salt = createSalt(); byte[] hash = createHash(customerModel.Password, salt); bool test = checkUser(customerModel.Username, customerModel.Email, customerModel.Phone); var newCustomer = new DBCustomer() { Username = customerModel.Username, Name = customerModel.Username, Surname = customerModel.Surname, Phone = customerModel.Phone, Email = customerModel.Email, Password = hash, Salt = salt }; try { if (test == true) { db.Customers.Add(newCustomer); db.SaveChanges(); return(true); } else { return(false); } } catch { return(false); } }
}//эта невиртуальная потому что для всех ролей одинаковый код protected void LoadSummon(ShowSummon ss) { ss.tbIDS.Text = ss.SVO.IDS; DBCustomer dbc = new DBCustomer(); ss.cbCustomers.ValueMember = "ID"; ss.cbCustomers.DisplayMember = "CNAME"; ss.cbCustomers.DataSource = dbc.GetAllCustomers(); ss.cbCustomers.SelectedValue = ss.SVO.IDCUSTOMER; if (ss.SVO.SISP) { ss.cbSISP.SelectedIndex = 1; } else { ss.cbSISP.SelectedIndex = 0; } DBAccept dbacc = new DBAccept(); ss.cbAccept.ValueMember = "ID"; ss.cbAccept.DisplayMember = "ANAME"; ss.cbAccept.DataSource = dbacc.GetAllAccept(); ss.cbAccept.SelectedValue = ss.SVO.IDACCEPT; DBPacking dbp = new DBPacking(); ss.cbPacking.ValueMember = "ID"; ss.cbPacking.DisplayMember = "PNAME"; ss.cbPacking.DataSource = dbp.GetAll(); ss.cbPacking.SelectedValue = ss.SVO.IDPACKING; //DBMountingKit dbmk = new DBMountingKit(); //ss.cbMountingKit.ValueMember = "ID"; //ss.cbMountingKit.DisplayMember = "MOUNTINGKITNAME"; //ss.cbMountingKit.DataSource = dbmk.GetAllDBMountingKitNames(); //ss.cbMountingKit.SelectedValue = ss.SVO.IDMOUNTINGKIT; ss.tbCONTRACT.Text = ss.SVO.CONTRACT; ss.tbDELIVERY.Text = ss.SVO.DELIVERY; ss.tbQUANTITY.Value = ss.SVO.QUANTITY; ss.tbSHIPPING.Text = ss.SVO.SHIPPING; ss.dtpCREATED.Value = ss.SVO.CREATED; ss.dtpPTIME.Value = ss.SVO.PTIME; ss.tbPayStatus.Text = ss.SVO.PAYSTATUS; ss.tbBillNumber.Text = ss.SVO.BILLNUMBER; /*if (ss.SVO.PASSDATE == null) * { * ss.chbDeterm.Checked = true; * ss.dtpAPPROX.Enabled = false; * } * else * { * ss.chbDeterm.Checked = false; * ss.dtpAPPROX.Enabled = false; * ss.dtpAPPROX.Value = (DateTime)ss.SVO.PASSDATE; * }*/ ss.tbStatus.Text = ss.SVO.STATUSNAME; ss.tbSubStatus.Text = ss.SVO.SUBSTATUSNAME; ss.chbBillPayed.Checked = ss.SVO.BILLPAYED; ss.chbDocsRdy.Checked = ss.SVO.DOCSREADY; if ((ss.Tag != null) && (ss.Tag.ToString() == "finished")) { ss.summonTransfer1.Visible = false; ss.summonTransfer2.Visible = false; } else { ss.summonNotes1.Init(ss.SVO.ID, this, ss.SVO); ss.summonNotes1.Reload(); ss.summonTransfer1.Init(ss.SVO, this, ss); if ((ss.SVO.ProductVO.GetProductType() == WPTYPE.CABLELIST) || (ss.SVO.ProductVO.GetProductType() == WPTYPE.ZHGUTLIST)) { ss.summonTransfer2.Visible = false; } ss.summonTransfer2.InitSub(ss.SVO, this, ss); } ss.wpNameView1.Init(ss.SVO.ProductVO.GetID(), ss.SVO.ProductVO.GetProductType(), this, ss.SVO); ss.cbCustDept.ValueMember = "ID"; ss.cbCustDept.DisplayMember = "DEPTNAME"; ss.cbCustDept.DataSource = dbc.GetDeptsByIDCustomer(ss.cbCustomers.SelectedValue.ToString()); ss.cbCustDept.SelectedValue = ss.SVO.IDCUSTOMERDEPT; if (ss.SVO.STATUSNAME != "Завершено") { if ((ss.Tag == null)) { DBSummon dbs = new DBSummon(); dbs.AddSummonView(ss.SVO, this); } } //ss.dtpApproxAtLoad = ss.SVO.PASSDATE; ss.cbCONTRACTTYPE.Text = ss.SVO.CONTRACTTYPE; //pfMETAL.IsPath = true; }//эта тоже
private void logInUser(String un) { var customerDB = new DBCustomer(); var founduser = customerDB.findCustomer(un); if(int.Parse(founduser.postalcode) < 1000) { founduser.postalcode = "0" + founduser.postalcode; if (int.Parse(founduser.postalcode) < 100) { founduser.postalcode = "0" + founduser.postalcode; if(int.Parse(founduser.postalcode) < 10) founduser.postalcode = "0" + founduser.postalcode; } } founduser.shoppingcart = new ShoppingCart(founduser.id); Session["loggedInUser"] = founduser; }
public ActionResult updateUserinfo(Customer newUser) { if (ModelState.IsValid) { Customer c = (Customer)Session["loggedInUser"]; var customerDB = new DBCustomer(); if (!customerDB.checkEmail(newUser.email,c.id)) { ViewBag.ok = "email er i bruk av annen bruker, velg en annen"; return View(); } c.firstname = newUser.firstname; c.lastname = newUser.lastname; c.email = newUser.email; c.phonenumber = newUser.phonenumber; c.address = newUser.address; c.postalcode = newUser.postalcode; c.postalarea = newUser.postalarea; bool updateOK = customerDB.update(c.id, c); if (updateOK) { Session["loggedInUser"] = c; TempData["changed"] = "Brukerinformasjon ble oppdatert"; return RedirectToAction("PersonalSite"); } else { Customer old = (Customer)Session["loggedInUser"]; ViewBag.ok = "klarte ikke oppdatere"; return View(); } } ViewBag.ok = "et felt er blankt, fyll det ut og trykk oppdater"; return View(); }
public ActionResult updateUserPassword(String op, String np, String bp) { if(Session["loggedInUser"]==null) return RedirectToAction("Frontpage", "Home"); if (ModelState.IsValid) { Customer c = (Customer)Session["loggedInUser"]; byte[] hpass = makeHash(op); if (Enumerable.SequenceEqual(c.hashpassword, hpass)) { if (np.Equals(bp)) { byte[] hashedPassword = makeHash(np); c.hashpassword = hashedPassword; var customerDB = new DBCustomer(); bool updateOK = customerDB.updatePw(c.id, hashedPassword); if (updateOK) { Session["loggedInUser"] = c; TempData["changed"] = "Passord ble endret"; return RedirectToAction("PersonalSite"); } else { ViewBag.correct = "klarte ikke oppdatere"; return View(); } } ViewBag.correct = "bekreftet ikke passordet riktig"; return View(); } ViewBag.correct = "ikke riktig nåværende passord"; return View(); } return RedirectToAction("PersonalSite"); }
protected override void Seed(DB context) { var salt = CustomerDAL.createSalt(); var newCustomer = new DBCustomer { Username = "******", Name = "Axel", Surname = "Bjørnstad", Phone = "12345678", Email = "*****@*****.**", Password = CustomerDAL.createHash("axel", salt), Salt = salt }; var customer1 = new DBCustomer { Username = "******", Name = "admin", Surname = "admin", Phone = "12345678", Email = "*****@*****.**", Password = CustomerDAL.createHash("admin", salt), Salt = salt, Admin = true }; Movie newMovie = new Movie { Title = "Utøya", Price = 99, Description = "En film om en edderkopp mann", Thumbnail = "https://secure.sfanytime.se/movieimages/COVER/db3d3b52-e4ab-4c05-b037-a8f500eaa498_COVER_NO.jpg" }; Movie newMovie2 = new Movie { Title = "Norske byggeklosser", Price = 56, Description = "En film om en flagermus mann", Thumbnail = "https://secure.sfanytime.se/movieimages/COVER/33343aab-4774-4b2f-b77e-a8c100f48d88_COVER_NO.jpg" }; Movie newMovie3 = new Movie { Title = "A quite place", Price = 129, Description = "En film fylt med action", Thumbnail = "https://secure.sfanytime.se/movieimages/COVER/8af70d64-10fb-4e49-a338-a8d5009dd7fd_COVER_NO.jpg" }; Movie newMovie4 = new Movie { Title = "Ready Player One", Price = 39, Description = "En veldig hyggelig barnefilm", Thumbnail = "https://secure.sfanytime.se/movieimages/COVER/39c9aef7-ac65-4a15-b304-a8da010616c5_COVER_NO.jpg" }; Category superhelt = new Category { Name = "Superhelter", }; Category action = new Category { Name = "Action" }; Category_Relation relation = new Category_Relation { Category = superhelt, Movie = newMovie }; Category_Relation relation2 = new Category_Relation { Category = superhelt, Movie = newMovie2 }; Category_Relation relation3 = new Category_Relation { Category = action, Movie = newMovie3 }; context.Movie.Add(newMovie); context.Movie.Add(newMovie2); context.Movie.Add(newMovie3); context.Movie.Add(newMovie4); context.Category.Add(superhelt); context.Category.Add(action); context.Category_Relations.Add(relation); context.Category_Relations.Add(relation2); context.Category_Relations.Add(relation3); context.Customers.Add(newCustomer); context.Customers.Add(customer1); context.SaveChanges(); base.Seed(context); }