protected void btnUpdate_Click(object sender, EventArgs e) { this.entidades = new marketsaveusEntities(); TblUser table = this.entidades.TblUser.FirstOrDefault(u => u.email == this.txtEmail.Text); if (table != null) { table.passw = this.txtPassword.Text; table.fullName = this.txtName.Text; char tipo; if (this.DropDownListTipe.Text.Equals("Administrador")) { tipo = 'a'; } else { tipo = 'c'; } table.tipo = tipo + ""; this.entidades.SaveChanges(); Response.Redirect("About.aspx"); } else { lbNotificaciones.Text = "The entered user is not registered"; } }
private void fillproducts(string pCode) { this.entidades = new marketsaveusEntities(); TblProduct products = this.entidades.TblProduct.FirstOrDefault(e => e.code == pCode); if (products != null) { this.txtCode.Text = products.code; this.txtDescripcion.Text = products.productDescription; this.txtInventory.Text = products.stock.ToString(); this.txtname.Text = products.productName; this.txtprize.Text = products.prize.ToString(); this.txtImage.Visible = false; this.lblImage.Visible = false; this.btnRegister.Visible = false; this.btnDelete.Visible = true; this.btnConsult.Visible = true; this.btnUpdate.Visible = true; this.txtCode.Enabled = false; } }
private bool intentoAutenticacion(string userName, string password) { try { bool autenticado = false; marketsaveusEntities entidades = new marketsaveusEntities(); user = entidades.TblUser.FirstOrDefault(u => u.fullName == userName); if (user != null) { if (user.passw.Equals(password)) { autenticado = true; } } return(autenticado); } catch (Exception ex) { throw ex; } }
private void fillInvoiceDesc(int id) { for (int i = 0; i < this.shoppingCart.Count; i++) { this.entities = new marketsaveusEntities(); TblDescInvoice tblDesc = new TblDescInvoice(); tblDesc.idInvoice = id; tblDesc.productCode = this.shoppingCart[i].code; tblDesc.quantity = int.Parse(this.shoppingCart[i].stock.ToString()); tblDesc.subtotal = decimal.Parse(this.shoppingCart[i].stock.ToString()) * this.shoppingCart[i].prize; this.entities.TblDescInvoice.Add(tblDesc); this.entities.SaveChanges(); } }
protected void btnDelete_Click(object sender, EventArgs e) { try { this.entidades = new marketsaveusEntities(); TblUser user = this.entidades.TblUser.FirstOrDefault(u => u.email == this.txtEmail.Text); this.entidades.TblUser.Remove(user); this.entidades.SaveChanges(); Response.Redirect("FRMUserRegistration.aspx"); } catch { lbNotificaciones.Text = "The entered user is not registered"; } }
protected void btnUpdate_Click(object sender, EventArgs e) { this.entidades = new marketsaveusEntities(); TblProduct products = this.entidades.TblProduct.FirstOrDefault(u => u.code == this.strCode); products.productDescription = this.txtDescripcion.Text; products.productName = this.txtname.Text; products.prize = Convert.ToDecimal(this.txtprize.Text); products.stock = Convert.ToInt32(this.txtInventory.Text); this.entidades.SaveChanges(); Response.Redirect("FrmConsultarProductos.aspx"); }
protected void btnDelete_Click(object sender, EventArgs e) { this.entidades = new marketsaveusEntities(); TblProduct products = this.entidades.TblProduct.FirstOrDefault(u => u.code == this.strCode); this.entidades.TblProduct.Remove(products); this.entidades.SaveChanges(); Response.Redirect("FrmConsultarProductos.aspx"); }
protected void btnBuy_Click(object sender, EventArgs e) { try { this.entities = new marketsaveusEntities(); int idInv = this.createInvoice(); if (idInv != -1) { this.fillInvoiceDesc(idInv); this.entities.SaveChanges(); Session["productsList"] = null; Response.Redirect("About.aspx"); } } catch (Exception ex) { throw ex; } }
protected void btnRegister_Click(object sender, EventArgs e) { this.entidades = new marketsaveusEntities(); string pcode = this.txtEmail.Text; TblUser tblUser = this.entidades.TblUser.FirstOrDefault(u => u.email == pcode); if (tblUser == null) { TblUser table = new TblUser(); table.email = this.txtEmail.Text; table.passw = this.txtPassword.Text; table.fullName = this.txtName.Text; char tipo; if (this.DropDownListTipe.Text.Equals("Administrador")) { tipo = 'a'; } else { tipo = 'c'; } table.tipo = tipo + ""; this.entidades.TblUser.Add(table); //se guardan los cambios Session["userName"] = table.fullName; Session["user"] = table.email; this.entidades.SaveChanges(); this.txtEmail.Text = ""; this.txtPassword.Text = ""; this.txtName.Text = ""; this.DropDownListTipe.Text = ""; Response.Redirect("About.aspx");///Falta pasarlo a lista clientes } else { lbNotificaciones.Text = "The entered user is already registered"; } }
protected void btnConsult_Click(object sender, EventArgs e) { this.entidades = new marketsaveusEntities(); TblUser table = this.entidades.TblUser.FirstOrDefault(u => u.email == this.txtEmail.Text); if (table != null) { this.txtPassword.Text = table.passw; this.txtName.Text = table.fullName; if (table.tipo.Equals("a")) { this.DropDownListTipe.Text = "Administrador"; } else { this.DropDownListTipe.Text = "Cliente"; } } else { lbNotificaciones.Text = "The entered user is not registered"; } }
protected void btnRegister_Click(object sender, EventArgs e) { this.entidades = new marketsaveusEntities(); string pcode = this.txtCode.Text; TblProduct tblProduct = this.entidades.TblProduct.FirstOrDefault(u => u.code == pcode); if (tblProduct == null) { TblProduct tableProduct = new TblProduct(); tableProduct.code = this.txtCode.Text; tableProduct.prize = Convert.ToDecimal(this.txtprize.Text); tableProduct.productDescription = this.txtDescripcion.Text; tableProduct.productName = this.txtname.Text; tableProduct.stock = Convert.ToInt32(this.txtInventory.Text); tableProduct.productImage = "www/img/" + txtImage.FileName; this.entidades.TblProduct.Add(tableProduct); //se guardan los cambios this.entidades.SaveChanges(); this.txtCode.Text = ""; this.txtDescripcion.Text = ""; this.txtInventory.Text = ""; this.txtname.Text = ""; this.txtprize.Text = ""; Response.Redirect("FrmConsultarProductos.aspx"); } else { lbNotificaciones.Text = "The number of the entered code is already saved, please enter a new one"; } }