protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { if (Request.Cookies.Get("user") != null) { HttpCookie cookie = Request.Cookies.Get("user"); int id = int.Parse(cookie.Value); TokoBediaDatabaseEntities entity = new TokoBediaDatabaseEntities(); var x = (from user in entity.Users where user.Id == id select user).FirstOrDefault(); Session["user"] = x; } else { Response.Redirect("Home1.aspx"); } } us = (Model.User)Session["user"]; LblWelcome.Text = Session["username"].ToString(); if (us.Role_Id == 1) { btnProductType.Visible = true; btnViewUser.Visible = true; } }
protected void loadgrid2() { TokoBediaDatabaseEntities db = new TokoBediaDatabaseEntities(); List <Product> test = new List <Product>(); Random rnd = new Random(); int value1 = 0; int value2 = 0; int value3 = 0; int value4 = 0; int value5 = 0; var v = db.Products.OrderByDescending(t => t.Product_Id).First(); var d = db.Products.OrderBy(c => c.Product_Id).First(); int e = GridView1.PageSize; do { value1 = rnd.Next(1, e); } while (DataRepository.checkProductId(value1) == null); do { value2 = rnd.Next(1, e); } while (DataRepository.checkProductId(value2) == null || value2 == value1); do { value3 = rnd.Next(1, e); } while (DataRepository.checkProductId(value3) == null || value3 == value1 || value3 == value2); do { value4 = rnd.Next(1, e); } while (DataRepository.checkProductId(value4) == null || value4 == value1 || value4 == value2 || value4 == value3); do { value5 = rnd.Next(1, e); } while (DataRepository.checkProductId(value5) == null || value5 == value1 || value5 == value2 || value5 == value3 || value5 == value4); var query = from g in db.Products join m in db.ProductTypes on g.ProductType_Id equals m.ProductType_Id where g.Product_Id == value1 || g.Product_Id == value2 || g.Product_Id == value3 || g.Product_Id == value4 || g.Product_Id == value5 select new { ProductId = g.Product_Id, ProductName = g.Product_Name, ProductStock = g.Product_Stock, ProductTypeName = m.ProductType_Name, ProductPrice = g.Product_Price }; GridView1.DataSource = query.ToList(); GridView1.DataBind(); }
protected void loadgrid() { TokoBediaDatabaseEntities db = new TokoBediaDatabaseEntities(); var query = from g in db.Users select new { UserEmail = g.Email, UserRole = g.Role_Id, UserStatus = g.Status }; GridView1.DataSource = query.ToList(); GridView1.DataBind(); }
protected void loadgrid() { TokoBediaDatabaseEntities db = new TokoBediaDatabaseEntities(); var query = from m in db.ProductTypes select new { ProductTypeId = m.ProductType_Id, ProductTypeName = m.ProductType_Name, ProductTypeDescription = m.ProductType_Description }; GridView1.DataSource = query.ToList(); GridView1.DataBind(); }
protected void loadgrid() { TokoBediaDatabaseEntities db = new TokoBediaDatabaseEntities(); var query = from g in db.Users where g.Id == us.Id select new { UserEmail = g.Email, UserName = g.Name, UserGender = g.Gender }; GridView1.DataSource = query.ToList(); GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { if (Request.Cookies.Get("user") != null) { HttpCookie cookie = Request.Cookies.Get("user"); int id = int.Parse(cookie.Value); TokoBediaDatabaseEntities entity = new TokoBediaDatabaseEntities(); var x = (from user in entity.Users where user.Id == id select user).FirstOrDefault(); Session["user"] = x; } else { Response.Redirect("Home1.aspx"); } } us = (Model.User)Session["user"]; if (us.Role_Id != 1) { TokoBediaDatabaseEntities db = new TokoBediaDatabaseEntities(); var query = from g in db.Products join m in db.ProductTypes on g.ProductType_Id equals m.ProductType_Id select new { ProductId = g.Product_Id, ProductName = g.Product_Name, ProductStock = g.Product_Stock, ProductTypeName = m.ProductType_Name, ProductPrice = g.Product_Price }; GridView1.DataSource = query.ToList(); btnGoInsert.Visible = false; btnGoUpdate.Visible = false; btnGoDelete.Visible = false; Label2.Visible = false; TBDeleteProduct.Visible = false; LblErrorDelete.Visible = false; loadgrid2(); } else { loadgrid(); } }
protected void loadgrid() { TokoBediaDatabaseEntities db = new TokoBediaDatabaseEntities(); var query = from g in db.Products join m in db.ProductTypes on g.ProductType_Id equals m.ProductType_Id select new { ProductId = g.Product_Id, ProductName = g.Product_Name, ProductStock = g.Product_Stock, ProductTypeName = m.ProductType_Name, ProductPrice = g.Product_Price }; GridView1.DataSource = query.ToList(); GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { if (Request.Cookies.Get("user") != null) { HttpCookie cookie = Request.Cookies.Get("user"); int id = int.Parse(cookie.Value); TokoBediaDatabaseEntities entity = new TokoBediaDatabaseEntities(); var x = (from user in entity.Users where user.Id == id select user).FirstOrDefault(); Session["user"] = x; } else { Response.Redirect("Home1.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] == null) { if (Request.Cookies.Get("user") != null) { HttpCookie cookie = Request.Cookies.Get("user"); int id = int.Parse(cookie.Value); TokoBediaDatabaseEntities entity = new TokoBediaDatabaseEntities(); var x = (from user in entity.Users where user.Id == id select user).FirstOrDefault(); Session["user"] = x; } else { Response.Redirect("Home1.aspx"); } } us = (Model.User)Session["user"]; TBEmail.Attributes["placeholder"] = Session["email"].ToString(); TBName.Attributes["placeholder"] = Session["username"].ToString(); }