public ActionResult Edit(Mcategory mcategory) { if (ModelState.IsValid) { string slug = Mystring.ToSlug(mcategory.name.ToString()); mcategory.slug = slug; mcategory.updated_at = DateTime.Now; mcategory.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Entry(mcategory).State = EntityState.Modified; try { var thisLink = db.Link.Where(m => m.tableId == 1 && m.parentId == mcategory.ID).First(); link tt_link = db.Link.Find(thisLink.ID); tt_link.slug = slug; tt_link.tableId = 1; tt_link.parentId = mcategory.ID; db.Entry(tt_link).State = EntityState.Modified; } catch (Exception) { //no runing } db.SaveChanges(); return(RedirectToAction("Index")); } Message.set_flash("Sửa thất bại", "success"); return(View(mcategory)); }
//Khi thanh toán Ngan Luong XOng public ActionResult confirm_orderPaymentOnline() { String Token = Request["token"]; RequestCheckOrder info = new RequestCheckOrder(); info.Merchant_id = nganluongInfo.Merchant_id; info.Merchant_password = nganluongInfo.Merchant_password; info.Token = Token; APICheckoutV3 objNLChecout = new APICheckoutV3(); ResponseCheckOrder result = objNLChecout.GetTransactionDetail(info); if (result.errorCode == "00") { String codeOrder = Session["OrderId"].ToString(); var OrderInfo = db.Orders.OrderByDescending(m => m.code == codeOrder).FirstOrDefault(); OrderInfo.StatusPayment = 1; db.Entry(OrderInfo).State = EntityState.Modified; db.SaveChanges(); ViewBag.paymentStatus = OrderInfo.StatusPayment; ViewBag.Methodpayment = OrderInfo.deliveryPaymentMethod; return(View("oderComplete", OrderInfo)); } else { ViewBag.status = false; } return(View("confirm_orderPaymentOnline")); }
public ActionResult Edit(Mslider mslider) { if (ModelState.IsValid) { string slug = Mystring.ToSlug(mslider.name.ToString()); HttpPostedFileBase file = Request.Files["img"]; string filename = file.FileName.ToString(); if (filename.Equals("") == false) { string ExtensionFile = Mystring.GetFileExtension(filename); string namefilenew = slug + "." + ExtensionFile; var path = Path.Combine(Server.MapPath("~/public/images/bg-images"), namefilenew); file.SaveAs(path); mslider.img = namefilenew; } mslider.url = slug; mslider.updated_at = DateTime.Now; mslider.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Entry(mslider).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.listCate = db.Sliders.Where(m => m.status != 0).ToList(); return(View(mslider)); }
//status public ActionResult Status(int id) { Morder morder = db.Orders.Find(id); db.Entry(morder).State = EntityState.Modified; db.SaveChanges(); Message.set_flash("Thay đổi trang thái thành công", "success"); return(RedirectToAction("Index")); }
//status public ActionResult Status(int id) { Morder morder = db.Orders.Find(id); morder.status = (morder.status == 1) ? 2 : 1; morder.updated_at = DateTime.Now; morder.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Entry(morder).State = EntityState.Modified; db.SaveChanges(); Message.set_flash("Thay đổi trang thái thành công", "success"); return(RedirectToAction("Index")); }
public virtual IQueryable <T> Items => set; // Можем переопределить в наследниках нюансы чтения\добавления сущностей // Добавление в бд public T Add(T item) { if (item is null) { throw new ArgumentNullException(nameof(item)); } db.Entry(item).State = EntityState.Added; // если элемент не пустой, то отмечаем сущность как добавленную if (AutoSaveChanges) { db.SaveChanges(); } return(item); }
public ActionResult Edit(Muser muser) { if (ModelState.IsValid) { muser.img = "ádasd"; muser.updated_at = DateTime.Now; muser.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Entry(muser).State = EntityState.Modified; db.SaveChanges(); Message.set_flash("Cập nhật thành công", "success"); return(RedirectToAction("Index")); } return(View(muser)); }
public ActionResult Edit(Product mbook, HttpPostedFileBase file) { if (ModelState.IsValid) { string slug = Mystring.ToSlug(mbook.name.ToString()); file = Request.Files["img"]; string filename = file.FileName.ToString(); if (filename.Equals("") == false) { var namecateDb = db.Categorys.Where(m => m.ID == mbook.catid).First(); string namecate = Mystring.ToStringNospace(namecateDb.name); string ExtensionFile = Mystring.GetFileExtension(filename); string namefilenew = namecate + "/" + slug + "." + ExtensionFile; var path = Path.Combine(Server.MapPath("~/public/images/product"), namefilenew); var folder = Server.MapPath("~/public/images/product/" + namecate); if (!Directory.Exists(folder)) { Directory.CreateDirectory(folder); } file.SaveAs(path); mbook.img = namefilenew; } mbook.slug = slug; try { var thisLink = db.Link.Where(m => m.tableId == 1 && m.parentId == mbook.ID).First(); link tt_link = db.Link.Find(thisLink.ID); tt_link.slug = slug; tt_link.tableId = 1; tt_link.parentId = mbook.ID; db.Entry(tt_link).State = EntityState.Modified; } catch (Exception) { //no runing } db.Entry(mbook).State = EntityState.Modified; db.SaveChanges(); ViewBag.listCate = db.Categorys.Where(m => m.status != 0 && m.ID > 2).ToList(); Message.set_flash("Sửa thành công", "success"); return(RedirectToAction("Index")); } Message.set_flash("Sửa thất bại", "danger"); ViewBag.listCate = db.Categorys.Where(m => m.status != 0 && m.ID > 2).ToList(); return(View(mbook)); }
public ActionResult Edit(Muser muser) { if (ModelState.IsValid) { muser.img = "ádasd"; muser.access = 0; muser.created_at = DateTime.Now; muser.updated_at = DateTime.Now; muser.created_by = int.Parse(Session["Admin_id"].ToString()); muser.updated_by = int.Parse(Session["Admin_id"].ToString()); db.Entry(muser).State = EntityState.Modified; db.SaveChanges(); Message.set_flash("Cập nhật thành công", "success"); ViewBag.role = db.Roles.Where(m => m.parentId == muser.access).First(); return(View("_information", muser)); } Message.set_flash("Cập nhật Thất Bại", "danger"); ViewBag.role = db.Roles.Where(m => m.parentId == muser.access).First(); return(View("Edit", muser)); }
public JsonResult Edit(Muser muser) { string new_pass = Mystring.ToMD5(muser.password); var pass_account = db.Users.Where(m => m.password == new_pass).ToList().Count(); var uname_account = db.Users.Where(m => m.username == muser.username && m.ID != muser.ID).ToList().Count(); if (pass_account == 0) { Message.set_flash("Mật khẩu không đúng", "danger"); return(Json(new { statuss = 1 }, JsonRequestBehavior.AllowGet)); } else if (uname_account > 0) { Message.set_flash("Tên đăng nhập đã tồn tại", "danger"); return(Json(new { statuss = 2 }, JsonRequestBehavior.AllowGet)); } else { if (ModelState.IsValid) { Muser muser1 = db.Users.Find(muser.ID); muser.access = muser1.access; muser.img = muser1.img; muser.status = muser1.status; muser.password = new_pass; muser.created_at = muser1.created_at; muser.updated_at = DateTime.Now; muser.created_by = muser1.created_by; muser.updated_by = muser1.ID; db.Entry(muser1).CurrentValues.SetValues(muser); db.SaveChanges(); Session[Common.CommonConstants.CUSTOMER_SESSION] = null; Session.Add(CommonConstants.CUSTOMER_SESSION, muser); Message.set_flash("Cập nhật thành công", "success"); return(Json(muser, JsonRequestBehavior.AllowGet)); } } return(Json(new { statuss = 3 }, JsonRequestBehavior.AllowGet)); }
static void Main(string[] args) { var optionsBuilder = new DbContextOptionsBuilder <BookstoreDbContext>(); optionsBuilder.UseSqlServer(ConnectionString); var context = new BookstoreDbContext(optionsBuilder.Options); context.Database.Migrate(); var saeedGanji = Author.Create("Saeed", "Ganji", new DateTime(1985, 1, 1)); context.Authors.Add(saeedGanji); context.SaveChanges(); // // context.Database.Migrate(); // context.Database.EnsureCreated(); // // var me = Author.Create("Saeed", "Ganji", DateTime.Now.AddDays(-1)); // me.AddBook("EF Core" , "132465"); // // var other = Author.Create("John", "Doe", DateTime.Now.AddDays(-1)); // other.AddBook("No Idea", "132465"); // // context.Authors.AddRange(me,other); // // context.SaveChanges(); Author me = null; // mention AsNoTracking in the article me = context.Authors.AsNoTracking().FirstOrDefault(x => x.FirstName == "Saeed"); me.AddBook("SampleBook", "1234567-890"); context.SaveChanges(); Console.WriteLine(context.Entry(me).Property("CreatedOn").CurrentValue); }
public async Task Update(T obj) { table.Attach(obj); _context.Entry(obj).State = EntityState.Modified; await Save(); }