public ActionResult OrderStatus_Create([DataSourceRequest] DataSourceRequest request, Tbl_OrderStatus model)
{
using (var Db = new ProjectWebEntities())
{
try
{
if (model != null)
{
// create new
if (model.Id == 0)
{
Db.Tbl_OrderStatus.Add(model);
Db.SaveChanges();
// Write log system---------
//Db.pr_LogSystem_save("Thêm mới dữ liệu(ID = " + model.ID + ")", "Thêm mới", 4, 9, User.Identity.Name, "Thành công", Request.UserHostAddress);
}
else // update current
{
Db.Entry(model).State = EntityState.Modified;
Db.SaveChanges();
// Write log system---------
//db.pr_LogSystem_save("Cập nhật dữ liệu(ID = " + model.OrderStatusId + ")", "Thêm mới", 4, 9, User.Identity.Name, "Thành công", Request.UserHostAddress);
}
}
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(RedirectToAction("Index", "OrderStatus"));
}
}
private List <Tbl_Role> GetRoleTree(int?parentId)
{
using (var Db = new ProjectWebEntities())
{
var list = new List <Tbl_Role>();
//var t = Db.tbl_Role.ToList();
var query = Db.Tbl_Role.AsEnumerable();
if (parentId == null)
{
query = query.Where(w => w.ParentId == null);
}
else
{
query = query.Where(w => w.ParentId == parentId);
}
//if (excludeId != null)
// query = query.Where(w => w.Id != excludeId);
//if (isUser)
//query.Include(i => i.Users);
//if (isGroup)
// query.Include(i => i.Groups);
var t = query.ToList();
foreach (var p in t)
{
list.Add(p);
list.AddRange(GetRoleTree(p.Id));
}
return(list);
}
}
public void ChangeIsHot(Tbl_News input)
{
using (var Db = new ProjectWebEntities())
{
try
{
var model = Db.Tbl_News.Find(input.Id);
model.IsHot = input.IsHot;
Db.Entry(model).State = EntityState.Modified;
Db.SaveChanges();
if (input.IsHot)
{
Db.pr_LogSystem_save("Thay đổi trạng thái của (" + model.Title + ") thành NỔI BẬT", "Cập nhật", "Dự án", User.Identity.Name);
}
else
{
Db.pr_LogSystem_save("Thay đổi trạng thái của (" + model.Title + ") thành KHÔNG NỔI BẬT", "Cập nhật", "Dự án", User.Identity.Name);
}
//Xóa cache
CacheHelper.ClearAllOutputCache();
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
}
}
public ActionResult Index()
{
using (var Db = new ProjectWebEntities())
{
return(View(Db.Tbl_News.Find(1)));
}
}
public List <RoleVM> SetRoleCbk(int gid, int?pid)
{
using (var Db = new ProjectWebEntities())
{
var lst = new List <RoleVM>();
IEnumerable <Tbl_Role> roles;
if (pid == null)
{
roles = Db.Tbl_Role.Where(t => t.ParentId == null);
}
else
{
roles = Db.Tbl_Role.Where(t => t.ParentId == pid);
}
foreach (var r in roles)
{
var nr = new RoleVM();
nr.Id = r.Id;
nr.Name = r.Name;
foreach (var gr in r.Tbl_Group)
{
if (gr.Id == gid)
{
nr.Selected = true;
}
}
lst.Add(nr);
}
return(lst);
}
}
public ActionResult Create(Tbl_Collection model)
{
using (var Db = new ProjectWebEntities())
{
try
{
model.IsHome = true;
// create new
if (model.Id == 0)
{
Db.Tbl_Collection.Add(model);
Db.SaveChanges();
Db.pr_LogSystem_save("Thêm mới dữ liệu(" + model.Name + ")", "Thêm mới", "Cam kết", User.Identity.Name);
}
else // update current
{
Db.Entry(model).State = EntityState.Modified;
Db.SaveChanges();
Db.pr_LogSystem_save("Cập nhật dữ liệu(" + model.Name + ")", "Cập nhật", "Cam kết", User.Identity.Name);
}
//Xóa cache
CacheHelper.ClearAllOutputCache();
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(RedirectToAction("Index", "Commit"));
}
}
public IEnumerable <AccountDO> getAccount()
{
using (var Db = new ProjectWebEntities())
{
var result = new List <AccountDO>();
foreach (var m in Db.Tbl_MemberAccount)
{
var tmp = new AccountDO();
tmp.Id = m.Id;
tmp.FullName = m.FirstName + " " + m.LastName;
tmp.Email = m.Email;
tmp.Password = m.Password;
tmp.Phone = m.Phone;
tmp.Address = m.Address;
tmp.ProvinceId = m.ProvinceId;
tmp.ProvinceName = m.Tbl_Province == null ? "" : m.Tbl_Province.ProName;
tmp.DistrictId = m.DistrictId;
tmp.DistrictName = m.Tbl_District == null ? "" : m.Tbl_District.DisName;
tmp.WardId = m.WardId;
tmp.WardName = m.Tbl_Ward == null ? "" : m.Tbl_Ward.WardName;
tmp.ImagePath = m.ImagePath;
tmp.Sex = m.Sex;
tmp.PIN = m.PIN;
tmp.DOB = m.DOB == null ? "" : m.DOB.Value.ToShortDateString();
tmp.DateCreate = m.DateCreate.ToShortDateString();
tmp.IsReceiptNewsLetter = m.IsReceiptNewsLetter;
tmp.Message = m.Message;
result.Add(tmp);
}
return(result);
}
}
public List <Tbl_News> GetIndividualPage()
{
using (var db = new ProjectWebEntities())
{
return(db.Tbl_News.Where(p => p.IsIndividualPage && p.IsDisable == false).ToList());
}
}
public JsonResult getProductType()
{
using (var db = new ProjectWebEntities())
{
List <ProductTypeDO> result = new List <ProductTypeDO>();
foreach (var item in db.Tbl_ProductType.Where(p => p.ParentId == null))
{
var model = new ProductTypeDO();
model.Id = item.Id;
model.Name = item.Name;
model.ParentID = item.ParentId;
model.IsDisable = item.IsDisable;
result.Add(model);
foreach (var it in GetProductTypeFAC(item.Id))
{
var model1 = new ProductTypeDO();
model1.Id = it.Id;
model1.Name = it.Name;
model1.ParentID = it.ParentID;
model1.IsDisable = it.IsDisable;
result.Add(model1);
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetMenuHome()
{
using (var Db = new ProjectWebEntities())
{
return(Json(Db.Tbl_MenuMultiLevel.Select(s => new { MenuId = s.MenuId, MenuCode = s.MenuCode, Menu = s.Menu, Url = s.Url, ParentId = s.ParentId, ProductId = s.ProductId, NewsId = s.NewsId, NewsTypeId = s.NewsTypeId, Icon = s.Icon, IsStatus = s.IsStatus }).ToList(), JsonRequestBehavior.AllowGet));
}
}
public string Generate_htmlFAC(int parentid)
{
using (var Db = new ProjectWebEntities())
{
string html_Result = "";
foreach (var item in Db.Tbl_ProductType.Where(p => p.ParentId == parentid))
{
if (Db.Tbl_ProductType.Where(p => p.ParentId == item.Id).Count() > 0)
{
html_Result = html_Result + "<li data-name='break' class= 'childbox' data-value='" + item.Id + "'>" + item.Name + "<ol>";
foreach (var it in Db.Tbl_ProductType.Where(p => p.ParentId == item.Id).ToList())
{
if (Db.Tbl_ProductType.Where(p => p.ParentId == it.Id).Count() > 0)
{
html_Result = html_Result + "<li data-name='break' >" + it.Name + "<ol>";
html_Result = html_Result + Generate_htmlFAC(it.Id);
html_Result = html_Result + "</ol></li>";
}
else
{
html_Result = html_Result + "<li data-name='ProType_" + it.Id + "' class='childbox' data-value='" + it.Id + "' data-checked='0' id='ProType_" + it.Id + "'>" + it.Name + "</li>";
}
}
html_Result = html_Result + "</ol></li>";
}
else
{
html_Result = html_Result + "<li data-name='ProType_" + item.Id + "' class='childbox' data-value='" + item.Id + "' data-checked='0' id='ProType_" + item.Id + "'>" + item.Name + "</li>";
}
}
return(html_Result);
}
}
public PartialViewResult _Row()
{
using (var db = new ProjectWebEntities())
{
return(PartialView("_Row", db.Tbl_MenuLink.Where(p => p.IsActive).ToList()));
}
}
public ActionResult RegisterFollowNews(string email)
{
using (var db = new ProjectWebEntities())
{
var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
var random = new Random();
var randomCode = new string(
Enumerable.Repeat(chars, 5)
.Select(s => s[random.Next(s.Length)])
.ToArray());
try
{
if (db.Tbl_FollowEmail.FirstOrDefault(p => p.Email == email) == null)
{
var mail = new Tbl_FollowEmail();
mail.Email = email;
mail.Code = DateTime.Now.Ticks + randomCode;
mail.IsDisable = GlobalVariables.status_Normal;
db.Tbl_FollowEmail.Add(mail);
db.SaveChanges();
}
}
catch (Exception ex)
{
_logger.Error("An Error Happened! ", ex);
}
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult OrderStatus_Destroy([DataSourceRequest] DataSourceRequest request, OrderStatusDO model)
{
using (var Db = new ProjectWebEntities())
{
try
{
var m = Db.Tbl_OrderStatus.Find(model.OrderStatusId);
if (m != null)
{
if (Db.Tbl_Order.FirstOrDefault(p => p.SatusId == m.Id) == null)
{
Db.Tbl_OrderStatus.Remove(m);
Db.SaveChanges();
}
// Write log system---------
//Db.pr_LogSystem_save("Xóa dữ liệu(ID = " + model.OrderStatusId + ")", "Xóa", 4, 9, User.Identity.Name, "Thành công", Request.UserHostAddress);
}
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
}
private static IEnumerable <OrderDetailDO> Get_doOrderDetails()
{
using (var db = new ProjectWebEntities())
{
var orderDetailList = new List <OrderDetailDO>();
var orderDetailTbl = db.Tbl_OrderDetail;
foreach (var item in orderDetailTbl)
{
var orderdetail = new OrderDetailDO();
//var discount = GetData.CheckPromotionPrograms(item.ProductId, item.Quantity, 0);
//string promo = "";
//foreach (var m in discount)
//{
// promo = promo + m.Name +", ";
//}
// orderdetail.PromotionProgram = promo;
orderdetail.OrderDetailID = item.Id;
orderdetail.OrderID = item.OrderId;
orderdetail.ProductID = item.ProductId;
orderdetail.ProductName = item.Tbl_Product.Name;
orderdetail.Quantity = item.Quantity;
orderdetail.RealPrice = String.Format("{0:0,0 đ}", item.RealPrice);
orderdetail.TotalPriceInProduct = String.Format("{0:0,0 đ}", item.TotalPrice);
orderDetailList.Add(orderdetail);
}
return(orderDetailList);
}
}
public List <ProductTypeDO> GetProductTypeFAC(int parent)
{
using (var db = new ProjectWebEntities())
{
List <ProductTypeDO> result = new List <ProductTypeDO>();
foreach (var item in db.Tbl_ProductType.Where(p => p.ParentId == parent).OrderByDescending(m => m.Sort.HasValue).ThenBy(p => p.Sort).ThenBy(p => p.Name))
{
var model = new ProductTypeDO();
model.Id = item.Id;
model.Name = item.Name;
model.ParentID = item.ParentId;
model.IsDisable = item.IsDisable;
result.Add(model);
foreach (var it in GetProductTypeFAC(item.Id))
{
var model1 = new ProductTypeDO();
model1.Id = it.Id;
model1.Name = it.Name;
model1.ParentID = it.ParentID;
model1.IsDisable = it.IsDisable;
result.Add(model1);
}
}
return(result);
}
}
private IEnumerable <DBOrderDO> Get_doOrder(DateTime FromDate, DateTime ToDate)
{
using (var Db = new ProjectWebEntities())
{
List <DBOrderDO> models = new List <DBOrderDO>();
try
{
List <pr_DashBoard_Order_Result> orders = Db.pr_DashBoard_Order(FromDate, ToDate).ToList();
foreach (var item in orders)
{
var model = new DBOrderDO();
model.OrderStatusName = item.OrderStatusName;
model.Color = item.Color;
model.Orders = item.Orders;
models.Add(model);
}
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(models);
}
}
public JsonResult deleteProductType(int id)
{
using (var db = new ProjectWebEntities())
{
try
{
var model = db.Tbl_ProductType.Find(id);
db.Tbl_ProductType.Remove(model);
//var menu = db.Tbl_MenuMultiLevel.Where(p => p.ProductId == id).ToList();
//if (menu.Any())
//{
// foreach (var item in menu)
// {
// db.Tbl_MenuMultiLevel.Remove(item);
// }
//}
db.SaveChanges();
db.pr_LogSystem_save("Xóa dữ liệu(" + model.Name + ")", "Xóa", "ProductType", User.Identity.Name);
//Xóa cache
CacheHelper.ClearAllOutputCache();
return(Json("Success", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
}
private bool checkInvaild(string username)
{
using (var Db = new ProjectWebEntities())
{
return(Db.Tbl_Account.Any(t => t.UserName == username));
}
}
public string getProductTypeChildForAjax(int id, int?idSelected, int?lasID)
{
using (var db = new ProjectWebEntities())
{
if (db.Tbl_ProductType.Count(p => p.ParentId == id) == 0)
{
return("");
}
var result = new List <ProductTypeDO>();
var _html = "";
_html = " <select name='ParentId' class='sleProductType form-control' id='ProductTypeID" + id + "'>";
_html = _html + " <option value=''>-- Lựa chọn --</option>";
foreach (var item in db.Tbl_ProductType.Where(p => p.ParentId == id))
{
if (idSelected == item.Id)
{
if (item.Id != lasID)
{
_html = _html + "<option selected='selected' value='" + item.Id + "'>" + item.Name + "</option>";
}
}
else
{
if (item.Id != lasID)
{
_html = _html + "<option value='" + item.Id + "'>" + item.Name + "</option>";
}
}
}
_html = _html + "</select>";
return(_html);
}
}
public ActionResult Delete_Account([DataSourceRequest] DataSourceRequest request, Tbl_MemberAccount model)
{
using (var Db = new ProjectWebEntities())
{
try
{
var m = Db.Tbl_MemberAccount.Find(model.Id);
if (model != null)
{
try
{
Db.Tbl_MemberAccount.Remove(m);
Db.SaveChanges();
// Write log system---------
Db.pr_LogSystem_save("Xóa dữ liệu(ID = " + model.Id + ")", "Xóa", "AccountMemBer", User.Identity.Name);
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
}
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
}
public JsonResult Create(List <Tbl_BannerDetail> model)
{
using (var db = new ProjectWebEntities())
{
try
{
var Sequence = 0;
foreach (var item in model)
{
Sequence++;
item.Sequence = Sequence;
if (item.Id > 0)
{
db.Entry(item).State = item.IsDelete ? EntityState.Deleted : EntityState.Modified;
}
else
{
db.Tbl_BannerDetail.Add(item);
}
}
db.SaveChanges();
//Xóa cache
CacheHelper.ClearAllOutputCache();
HttpResponse.RemoveOutputCacheItem(Url.Action("Index", "Banner"));
}
catch (Exception ex)
{
TempData["ThanhCong"] = "Có lỗi xảy ra ! <br/> Xin vui lòng thử lại hoặc liên hệ Admin";
_logger.Error("An Error Happened! ", ex);
return(Json(JsonRequestBehavior.DenyGet));
}
return(Json(JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create([DataSourceRequest] DataSourceRequest request, Tbl_AboutUs model)
{
using (var db = new ProjectWebEntities())
{
try
{
if (model != null)
{
// update
if (model.Id != 0)
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
}
}
//Xóa cache
CacheHelper.ClearAllOutputCache();
}
catch (Exception ex)
{
_logger.Error("An Error Happened! ", ex);
}
TempData["ThanhCong"] = "Cập nhật thành công !";
return(RedirectToAction("Create", "AboutUs"));
}
}
public ActionResult Create(FormCollection form)
{
using (var Db = new ProjectWebEntities())
{
var gr = new Tbl_Group();
try
{
gr.Name = form["groupname"];
gr.Description = form["description"];
//gr.UserID = WebContext.Current.UserId;
Db.Tbl_Group.Add(gr);
Db.SaveChanges();
ViewBag.Message = "Successful";
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
string err = "";
var exs = dbEx.EntityValidationErrors;
foreach (var e in dbEx.EntityValidationErrors)
{
foreach (var erEx in e.ValidationErrors)
{
err += erEx.ErrorMessage + " | ";
}
}
//ViewBag.Message = err;
logger.Error("An Error Happened! ", dbEx);
}
return(RedirectToAction("Index", "RightGroup"));
}
}
private void SetUserRole(int userId, string roleIDs)
{
using (var Db = new ProjectWebEntities())
{
var user = Db.Tbl_Account.Where(w => w.Id == userId).Include(i => i.Tbl_Role).SingleOrDefault();
if (user != null)
{
var roleArr = roleIDs.Split(',');
if (user.Tbl_Role != null)
{
user.Tbl_Role.Clear();
}
foreach (var roleId in roleArr)
{
var rid = Convert.ToInt32(roleId);
var r = Db.Tbl_Role.SingleOrDefault(w => w.Id == rid);
if (r != null)
{
user.Tbl_Role.Add(r);
}
}
//this.Repository.Update<User>(user,true);
Db.SaveChanges();
}
}
}
public ActionResult ChangePassword(Tbl_Account model)
{
using (var Db = new ProjectWebEntities())
{
try
{
string oldPass = Request.Form["OldPassword"] ?? "";
if (Check_Login(model.UserName, oldPass))
{
string key = GlobalVariables.Cus_Key;
if (model.UserName == "BeeAdmin")
{
key = GlobalVariables.Bee_Key;
}
var account = Db.Tbl_Account.FirstOrDefault(p => p.UserName == model.UserName);
model.Password = Md5.VT_Encrypt(key, model.Password);
account.Password = model.Password;
Db.Entry(account).State = EntityState.Modified;
Db.SaveChanges();
}
else
{
return(View(model));
}
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult destroyNews([DataSourceRequest] DataSourceRequest request, Tbl_News model)
{
using (var Db = new ProjectWebEntities())
{
try
{
var m = Db.Tbl_News.Find(model.Id);
if (model != null)
{
try
{
Db.Tbl_News.Remove(m);
Db.SaveChanges();
// Write log system---------
Db.pr_LogSystem_save("Xóa dữ liệu(ID = " + model.Id + ")", "Xóa", "News", User.Identity.Name);
}
catch (Exception ex)
{
// Write log system---------
Db.pr_LogSystem_save("Xóa dữ liệu(ID = " + model.Id + ")", "Xóa", "News", User.Identity.Name);
logger.Error("An Error Happened! ", ex);
}
}
//Xóa cache
CacheHelper.ClearAllOutputCache();
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
}
public JsonResult GetOrderStatus()
{
using (var Db = new ProjectWebEntities())
{
return(Json(Db.Tbl_OrderStatus.Select(m => new { OrderStatusId = m.Id, OrderStatus = m.Name }).ToList(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create(Tbl_News model)
{
using (var Db = new ProjectWebEntities())
{
try
{
model.DateCreate = DateTime.Now;
model.NewsTypeId = 2;
// create new
if (model.Id == 0)
{
Db.Tbl_News.Add(model);
Db.SaveChanges();
Db.pr_LogSystem_save("Thêm mới dữ liệu(ID = " + model.Id + ")", "Thêm mới", "Tin tức", User.Identity.Name);
//Repository.ClearCache(); // clear cache
}
else // update current
{
Db.Entry(model).State = EntityState.Modified;
Db.SaveChanges();
Db.pr_LogSystem_save("Cập nhật dữ liệu(ID = " + model.Id + ")", "Cập nhật", "Tin tức", User.Identity.Name);
}
//Xóa cache
CacheHelper.ClearAllOutputCache();
}
catch (Exception ex)
{
logger.Error("An Error Happened! ", ex);
}
return(RedirectToAction("Index", "Project"));
}
}
public CartVM GetOrer()
{
using (var db = new ProjectWebEntities())
{
var model = new CartVM();
//var httpCookie = HttpContext.Current.Request.Cookies["loginPIN"];
//if (httpCookie != null)
//{
// var pin = httpCookie.Value;
// model.ItemMember = db.Tbl_MemberAccount.SingleOrDefault(p => p.PIN ==pin);
//}
model.ListProvinces = db.Tbl_Province.OrderByDescending(p => p.Type).ToList();
model.ListDistricts = db.Tbl_District.OrderByDescending(p => p.ProId).ThenBy(p => p.DisId).ToList();
var listProduct = new List <Tbl_Product>();
model.TotalPrice = 0;
for (int i = 0; i < HttpContext.Current.Request.Cookies.Count; i++)
{
var productCookie = HttpContext.Current.Request.Cookies[i];
if (productCookie != null && productCookie.Name.Contains("e0jwun4lc5_"))
{
var id = Convert.ToInt32(productCookie.Value.Split('|')[0]);
var product = db.Tbl_Product.Find(id);
product.Quantity = Convert.ToInt32(productCookie.Value.Split('|')[1]);
product.TotalPriceProduct = product.RealPrice * product.Quantity;
model.TotalPrice = model.TotalPrice + product.TotalPriceProduct;
model.TotalAllPrice = model.TotalPrice;
listProduct.Add(product);
}
}
model.ListProducts = listProduct.OrderBy(p => p.Name).ToList();
return(model);
}
}
