public void DeleteComment(Comment p) { int index = p.CommentId; DB mDB = new DAL.DB(); List <Comment> comList = mDB.CommentDB.ToList(); Comment comment = comList.Where(us => us.CommentId == index).FirstOrDefault(); mDB.CommentDB.Remove(comment); mDB.SaveChanges(); }
public void DeletePhoto(Photo p) { int index = p.PhotoId; DB mDB = new DAL.DB(); List <Photo> photoList = mDB.PhotoDB.ToList(); Photo photo = photoList.Where(us => us.PhotoId == index).FirstOrDefault(); mDB.PhotoDB.Remove(photo); mDB.SaveChanges(); }
public void DeleteItem(Item p) { int index = p.ItemId; DB mDB = new DAL.DB(); List <Item> postList = mDB.ItemDB.ToList(); Item item = postList.Where(us => us.ItemId == index).FirstOrDefault(); mDB.ItemDB.Remove(item); mDB.SaveChanges(); }
public void DeleteOrder(Order p) { int index = p.OrderId; DB mDB = new DAL.DB(); List <Order> orderList = mDB.OrderDB.ToList(); Order order = orderList.Where(us => us.OrderId == index).FirstOrDefault(); mDB.OrderDB.Remove(order); mDB.SaveChanges(); }
public void DeleteVideo(Video v) { int index = v.VideoId; DB mDB = new DAL.DB(); List <Video> postList = mDB.VideoDB.ToList(); Video video = postList.Where(us => us.VideoId == index).FirstOrDefault(); mDB.VideoDB.Remove(video); mDB.SaveChanges(); }
public void DeleteConcert(Tour t) { int index = t.TourId; DB mDB = new DAL.DB(); List <Tour> postList = mDB.TourDB.ToList(); Tour tour = postList.Where(us => us.TourId == index).FirstOrDefault(); mDB.TourDB.Remove(tour); mDB.SaveChanges(); }
public void DeletePost(Post p) { int index = p.PostId; DB mDB = new DAL.DB(); List <Post> postList = mDB.PostDB.ToList(); Post post = postList.Where(us => us.PostId == index).FirstOrDefault(); mDB.PostDB.Remove(post); mDB.SaveChanges(); }
public Repository() { Context = new DAL.DB(); }
public ActionResult Login(Account user, string ReturnUrl) //Autoryzacja Logownie { var url = ViewBag.ReturnUrl; AuthorizationVM avm = new AuthorizationVM(); using (DAL.DB db = new DAL.DB()) { //var tym = Encrypt.GetHash(user.password); var userdeatils = db.Accounts.Where(x => x.Login == user.Login && x.Password == user.Password).FirstOrDefault(); if (userdeatils == null) { ViewBag.LoginErrorMessage = "Niepoprawny login lub hasło"; return(View("Login", user)); } else { if (userdeatils.Active == false) { ViewBag.LoginErrorMessage = "Konto nie aktywowane"; return(View("Login", user)); } /// int licznik; List <Book> tmp = (List <Book>)Session["Zamowienie"]; if (tmp != null) { licznik = tmp.Count(); } else { licznik = 0; } Session["Licznik"] = licznik; /// Session["adminID"] = userdeatils.AccountID; Session["login"] = userdeatils.Login; if (userdeatils.Role == Role.Admin) { Session["IsAdmin"] = 1; // jest adminem } else if (userdeatils.Role == Role.Worker) { Session["IsAdmin"] = 2; // jest pracownikiem } else { Session["IsAdmin"] = 3; // jest czytaczem } FormsAuthentication.SetAuthCookie(user.Login, false); if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } else { return(RedirectToAction("Index", "Home")); } } } }