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();
}