protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && !HttpContext.Current.User.Identity.IsAuthenticated) { Response.RedirectToRoute("login"); return; } if (Security.Authorizate(HttpContext.Current.User.Identity.Name) == Security.SystemRoles.User) { Response.RedirectToRoute("login"); return; } int sectionId; if (int.TryParse(Request.Form["remove"], out sectionId)) { using (AuctionEntities au = new AuctionEntities()) { Section section = au.Sections .First(s => s.Id == sectionId); if (section != null && section.Id != 1) { au.Sections.Remove(section); au.SaveChanges(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && !HttpContext.Current.User.Identity.IsAuthenticated) { Response.RedirectToRoute("login"); return; } if (!Page.IsPostBack && HttpContext.Current.User.Identity.IsAuthenticated) { using (AuctionEntities au = new AuctionEntities()) { User user = au.Users .First(u => u.Login == HttpContext.Current.User.Identity.Name); LoginInfo.Text = user.Login; RoleInfo.Text = user.Role.NameRole; NameInfo.Text = user.Name; EmailInfo.Text = user.Email; AddressInfo.Text = user.Address; PhoneInfo.Text = user.Phone; MyLotsInfo.Text = au.UserLots .Count(ul => ul.IdUser == user.Id && ul.idStatus == 1).ToString(); SellLotsInfo.Text = au.UserLots .Count(ul => ul.IdUser == user.Id && ul.idStatus == 4).ToString(); BuyLotsInfo.Text = au.UserLots .Count(ul => ul.IdUser == user.Id && ul.idStatus == 5).ToString(); } } }
protected void EmailCheckValidator_ServerValidate(object source, ServerValidateEventArgs args) { using (AuctionEntities au = new AuctionEntities()) { args.IsValid = !(au.Users .Any(u => u.Email == emailBox.Text)); } }
protected void nameCheckValidator_ServerValidate(object source, ServerValidateEventArgs args) { using (AuctionEntities au = new AuctionEntities()) { args.IsValid = !(au.Sections .Any(s => s.NameSection == nameBox.Text)); } }
protected void UserExistValidator_ServerValidate(object source, ServerValidateEventArgs args) { using (AuctionEntities au = new AuctionEntities()) { args.IsValid = !(au.Users .Any(u => u.Login == loginBox.Text)); } }
public static bool Authenticate(string login, string password) { using (AuctionEntities au = new AuctionEntities()) { return au.Users .Any(u => u.Login == login && u.Password == password); } }
protected void PswValidator_ServerValidate(object source, ServerValidateEventArgs args) { using (AuctionEntities au = new AuctionEntities()) { args.IsValid = (au.Users .Count(u => u.Login == HttpContext.Current.User.Identity.Name && u.Password == oldPswBox.Text) == 1); } }
public static SystemRoles Authorizate(string login) { using (AuctionEntities au = new AuctionEntities()) { int role = au.Users .Where(u => u.Login == login) .Select(u => u.IdRole) .FirstOrDefault(); return (SystemRoles)role; } }
protected void RegButton_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { using (AuctionEntities au = new AuctionEntities()) { User user = new User(); user.Login = loginBox.Text; user.Password = passBox.Text; user.Email = emailBox.Text; user.IdRole = roleId; Methods.AddUser(user); RegMultiView.ActiveViewIndex = 1; } } }
protected void PswSaveBtn_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { using (AuctionEntities au = new AuctionEntities()) { User user = au.Users .First(u => u.Login == HttpContext.Current.User.Identity.Name); if (user != null) { user.Password = newPswBox.Text; Methods.AddUser(user); ChangePswView.ActiveViewIndex = 1; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && !HttpContext.Current.User.Identity.IsAuthenticated) { Response.RedirectToRoute("login"); return; } if (!Page.IsPostBack && HttpContext.Current.User.Identity.IsAuthenticated) { if (Security.Authorizate(HttpContext.Current.User.Identity.Name) == Security.SystemRoles.User) { Response.RedirectToRoute("login"); return; } MultiView.ActiveViewIndex = 0; int sectionId; int.TryParse((string)Page.RouteData.Values["editsection"] ?? Request.QueryString["editsection"], out sectionId); if (sectionId == 1) { Response.RedirectToRoute("sectionmng"); return; } else { if (sectionId != 0) { using (AuctionEntities au = new AuctionEntities()) { section = au.Sections.First(s => s.Id == sectionId); nameBox.Text = section.NameSection; } } } } }
protected void saveBtn_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { using (AuctionEntities au = new AuctionEntities()) { User user = au.Users .First(u => u.Login == HttpContext.Current.User.Identity.Name); if (user != null) { user.Name = nameBox.Text; user.Address = addressBox.Text; user.Phone = phoneBox.Text; Methods.AddUser(user); MultiView.ActiveViewIndex = 1; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && !HttpContext.Current.User.Identity.IsAuthenticated) { Response.RedirectToRoute("login"); return; } if (!Page.IsPostBack && HttpContext.Current.User.Identity.IsAuthenticated) { MultiView.ActiveViewIndex = 0; using (AuctionEntities au = new AuctionEntities()) { User user = au.Users .First(u => u.Login == HttpContext.Current.User.Identity.Name); nameBox.Text = user.Name; addressBox.Text = user.Address; phoneBox.Text = user.Phone; } } }
public static string RandomLotImg() { using (AuctionEntities au = new AuctionEntities()) { int rnd = new Random().Next(au.Lots.Count()); string imgTag = au.Lots .OrderBy(l => l.IdLot) .Skip(rnd) .Select(l => l.Img) .First(); int lotId = au.Lots.Where(l => l.Img == imgTag) .Select(l => l.IdLot) .First(); Lot lot = au.Lots.First(l => l.IdLot == lotId); string link = UrlCreater.CreateUrl(lot); string name = lot.Name; return imgTag + "*/*" + link + "*/*" + name; } }
private void AddLot(Lot lot, DateTime date, AuctionEntities au) { Random rnd = new Random(); lot.Name = nameBox.Text; lot.IdSection = au.Sections .Where(s => s.NameSection == ddlSection.SelectedValue) .Select(s => s.Id) .First(); lot.Description = descBox.Text; lot.Tick = Convert.ToDecimal(tickBox.Text); switch (ddlEndDate.SelectedIndex) { case 0: lot.EndDate = date.AddHours(1); break; case 1: lot.EndDate = date.AddDays(1); break; case 2: lot.EndDate = date.AddDays(7); break; case 3: lot.EndDate = date.AddMonths(1); break; } HttpPostedFile ps = Request.Files["filefield"]; if ((ps != null) && (ps.ContentLength > 0)) { string fn = System.IO.Path.GetFileName(ps.FileName); string fileName = rnd.Next(99999) + fn; lot.Img = fileName; string SaveLocation = Server.MapPath("~/DataBase/Images") + "\\" + fileName; ps.SaveAs(SaveLocation); } Methods.AddLot(lot, au); }
protected void saveBtn_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { int sectionId; int.TryParse((string)Page.RouteData.Values["editsection"] ?? Request.QueryString["editsection"], out sectionId); if (sectionId != 0) { using (AuctionEntities au = new AuctionEntities()) { section = au.Sections.First(s => s.Id == sectionId); section.NameSection = nameBox.Text; Methods.AddSection(section); MultiView.ActiveViewIndex = 1; } } else { using (AuctionEntities au = new AuctionEntities()) { Section newSection = new Section(); newSection.NameSection = nameBox.Text; Methods.AddSection(newSection); MultiView.ActiveViewIndex = 1; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && !HttpContext.Current.User.Identity.IsAuthenticated) { Response.RedirectToRoute("login"); return; } if (!Page.IsPostBack && HttpContext.Current.User.Identity.IsAuthenticated) { MultiView.ActiveViewIndex = 0; int lotId; int.TryParse((string)Page.RouteData.Values["editlot"] ?? Request.QueryString["editlot"], out lotId); if (lotId != 0) { if (Security.Authorizate(HttpContext.Current.User.Identity.Name) == Security.SystemRoles.User) { using (AuctionEntities au = new AuctionEntities()) { User user = au.Users .First(u => u.Login == HttpContext.Current.User.Identity.Name); if (!au.UserLots.Any(ul => ul.IdLot == lotId && ul.IdUser == user.Id && ul.idStatus == 1)) { Response.RedirectToRoute("userlots"); return; } } } using (AuctionEntities au = new AuctionEntities()) { lot = au.Lots.First(l => l.IdLot == lotId); if (lot.Status == false) { Response.RedirectToRoute("lotsmng"); } else { nameBox.Text = lot.Name; ddlSection.SelectedValue = lot.Section.NameSection; startDateBox.Text = lot.StartDate.ToString("dd.MM.yyyy, HH:mm"); TimeSpan dt = lot.EndDate - lot.StartDate; switch (dt.Days) { case 1: ddlEndDate.SelectedIndex = 1; break; case 7: ddlEndDate.SelectedIndex = 2; break; case 30: ddlEndDate.SelectedIndex = 3; break; default: ddlEndDate.SelectedIndex = 0; break; } startPriceBox.Enabled = false; startPriceBox.Text = lot.StartPrice.ToString(); tickBox.Text = lot.Tick.ToString(); descBox.Text = lot.Description; } } } else { startDateBox.Text = DateTime.Now.ToString("dd-MM-yyyy, HH:mm"); } } }
protected void saveBtn_Click(object sender, EventArgs e) { Page.Validate(); if (Page.IsValid) { int lotId; int.TryParse((string)Page.RouteData.Values["editlot"] ?? Request.QueryString["editlot"], out lotId); if (lotId !=0) { using (AuctionEntities au = new AuctionEntities()) { using (var tran = au.Database.BeginTransaction()) { try { lot = au.Lots.First(l => l.IdLot == lotId); AddLot(lot, lot.StartDate, au); au.SaveChanges(); tran.Commit(); lblError.Text = "Лот успешно изменен!"; MultiView.ActiveViewIndex = 1; Methods.UpdateLotsStatus(); } catch (Exception) { tran.Rollback(); } } } } else { HttpPostedFile ps = Request.Files["filefield"]; if ((ps != null) && (ps.ContentLength <= 0)) { lblError.Text = "Изображение не выбрано!"; return; } using (AuctionEntities au = new AuctionEntities()) { using (var tran = au.Database.BeginTransaction()) { try { Lot newLot = new Lot(); newLot.StartDate = DateTime.Now; newLot.StartPrice = Convert.ToDecimal(startPriceBox.Text); newLot.CurrentPrice = Convert.ToDecimal(startPriceBox.Text); newLot.Status = true; AddLot(newLot, DateTime.Now, au); int userId = au.Users .Where(u => u.Login == HttpContext.Current.User.Identity.Name) .Select(u => u.Id) .First(); UserLot userLot = new UserLot(); userLot.IdLot = newLot.IdLot; userLot.IdUser = userId; userLot.idStatus = 1; Methods.AddUserLot(userLot, au); au.SaveChanges(); tran.Commit(); lblError.Text = "Лот успешно добавлен!"; MultiView.ActiveViewIndex = 1; Methods.UpdateLotsStatus(); } catch (Exception) { tran.Rollback(); } } } } } }