public int Create(Brand item) { Entity.Brand brand = new Entity.Brand(); brand.id = item.id; brand.name = item.name; database.Brands.Add(brand); database.SaveChanges(); return(1); }
public int Create(CategoryView item) { Entity.Category cate = new Entity.Category() { id = item.id, name_category = item.name_category, status = item.status }; database.Categories.Add(cate); database.SaveChanges(); return(cate.id); }
public int Create(CustomerView item) { try { Models.Entity.Customer c = new Entity.Customer() { first_name = item.first_name, last_name = item.last_name, phone = item.phone, email = item.email, address = item.address, username = item.username, password = item.password, status = item.status }; db.Customers.Add(c); db.SaveChanges(); return(1); } catch (EntityException ex) { Debug.WriteLine(ex.Message); return(0); } }
public int Create(OrderDetail item) { Entity.OrderDetail orderD = new Entity.OrderDetail() { id = item.id, id_orders = item.id_orders, id_product = item.id_product, quantity = item.quantity, sub_total = item.sub_total, status = item.status }; database.OrderDetails.Add(orderD); database.SaveChanges(); return(1); }
public int Create(OrderView item) { Models.Entity.Order order = new Entity.Order() { id = item.id, email_order = item.email_order, address_order = item.address_order, phone_order = item.phone_order, id_customer = item.id_customer, order_date = item.order_date, total = item.total, status = item.status }; database.Orders.Add(order); database.SaveChanges(); return(order.id); }
public int Create(ProductView item) { try { if (checkNameProduct(item.name_product) == false) { Entity.Product pro = new Entity.Product() { id = item.id, name_product = item.name_product, name_image = item.name_image, id_brand = item.id_brand, id_category = item.id_category, description = item.description, discount = item.discount, price = item.price, created = item.created, status = item.status }; database.Products.Add(pro); database.SaveChanges(); return(1); } return(0); } catch (Exception) { return(0); } }
public ActionResult Forget_Password() { Models.Dao.Security s = new Models.Dao.Security(); Models.Entity.ChocoGearEntities db = new Models.Entity.ChocoGearEntities(); var username = Request.Form["user"]; var email = Request.Form["email"]; var string_default = "aptechloveindia"; var tmp = username + string_default; var tmp1 = s.Base64(tmp); var tmp2 = s.MD5Hash(tmp1); if (s.Check_email_username(email, username)) { var q = db.Customers.Single(d => d.email == email && d.username == username); q.password = tmp2; db.SaveChanges(); //Send Mail var senderEmail = new MailAddress("*****@*****.**", "ChocoGear"); var receiverEmail = new MailAddress(email, "Receiver"); var password = "******"; var sub = "Order Gear"; var body = string_default; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(senderEmail.Address, password) }; using (var mess = new MailMessage(senderEmail, receiverEmail) { Subject = sub, Body = body }) { smtp.Send(mess); } return(Json("Success")); } else { return(Json("Email, Username are not available")); } }
public int Create(FeedBackView item) { try { Entity.Feedback fb = new Entity.Feedback() { id = item.id, email = item.email, content = item.content, created = item.created, status = item.status }; db.Feedbacks.Add(fb); db.SaveChanges(); return(1); } catch (Exception) { return(0); } }
public ActionResult Create_ChangePassword() { var id = int.Parse(Request.Form["id_cus"]); var username = Request.Form["username"]; var password_old = Request.Form["pass_old"]; var password_new = Request.Form["pass_new"]; var password_new_cf = Request.Form["pass_new_cf"]; Models.Dao.Security s = new Models.Dao.Security(); var tmp_old = username + password_old; var tmp_old1 = s.Base64(tmp_old); var tmp_old2 = s.MD5Hash(tmp_old1); var tmp_new = username + password_new; var tmp_new1 = s.Base64(tmp_new); var tmp_new2 = s.MD5Hash(tmp_new1); Models.Entity.ChocoGearEntities db = new Models.Entity.ChocoGearEntities(); if (password_old == "" || password_new == "" || password_new_cf == "") { var a = "Please fill in your PassWord"; return(Json(a)); } else { if (tmp_old2 == tmp_new2) { return(Json("Password already exists")); } else { if (s.CheckPass(tmp_old2)) { var q = db.Customers.Single(d => d.id == id); q.password = tmp_new2; db.SaveChanges(); return(Json("Success")); } else { return(Json("PassWord Old Wrong")); } } } }