public void Add(Category obj)
{
HelperCache.RemoveCache(KeyCache);
HelperCache.RemoveCache(KeyCacheView);
_entities.Categories.Add(obj);
_entities.SaveChanges();
}
public void Edit(Category obj)
{
HelperCache.RemoveCache(KeyCache);
HelperCache.RemoveCache(KeyCacheView);
_entities.Entry(obj).State = EntityState.Modified;
_entities.SaveChanges();
}
public ActionResult UpdatePosition(string value)
{
var arrValue = value.Split('|');
HelperCache.RemoveCache(Keycache);
foreach (var item in arrValue)
{
var id = item.Split(':')[0];
var pos = item.Split(':')[1];
var obj = _adminMenuRepository.Find(Convert.ToInt32(id));
obj.Ordering = Convert.ToInt32(pos);
try
{
_adminMenuRepository.Edit(obj);
}
catch (Exception)
{
return(Json(new
{
IsSuccess = false,
Messenger = string.Format("Cập nhật vị trí thất bại")
}, JsonRequestBehavior.AllowGet));
}
}
return(Json(new
{
IsSuccess = true,
Messenger = "Cập nhật vị trí thành công",
}, JsonRequestBehavior.AllowGet));
}
public void Delete(int id)
{
HelperCache.RemoveCache(KeyCache);
var obj = Find(id);
_entities.tbl_Gallery.Remove(obj);
_entities.SaveChanges();
}
public void Delete(int id)
{
HelperCache.RemoveCache(KeyCache);
var obj = Find(id);
_entities.AdminMenus.Remove(obj);
_entities.SaveChanges();
}
public void Delete(int id)
{
HelperCache.RemoveCache(KeyCache);
HelperCache.RemoveCache(KeyCacheView);
var obj = Find(id);
_entities.Categories.Remove(obj);
_entities.SaveChanges();
}
public List <AdminMenu> GetAll()
{
var lstData = HelperCache.GetCache <List <AdminMenu> >(KeyCache);
if (lstData == null)
{
lstData = _entities.AdminMenus.ToList();
HelperCache.AddCache(lstData, KeyCache);
}
return(lstData);
}
public List <Category> GetAll()
{
var lstData = HelperCache.GetCache <List <Category> >(KeyCache);
if (lstData == null)
{
lstData = _entities.Categories.ToList();
HelperCache.AddCache(lstData, KeyCache);
}
return(lstData);
}
public IEnumerable <Model.tbl_Gallery> GetAll()
{
var lstData = HelperCache.GetCache <List <tbl_Gallery> >(KeyCache);
if (lstData == null)
{
lstData = _entities.tbl_Gallery.OrderByDescending(g => g.CreatedDate).ToList();
HelperCache.AddCache(lstData, KeyCache);
}
return(lstData);
}
public void AddOrderDetail(OrderDetail model)
{
HelperCache.RemoveCache(KeyCache);
object[] parameters =
{
new SqlParameter("@ProductID", model.ProductID),
new SqlParameter("@OrderID", model.OrderID),
new SqlParameter("@Quantity", model.Quantity)
};
_entities.Database.ExecuteSqlCommand("Sp_OrderDetail_Insert @ProductID,@OrderID,@Quantity", parameters);
}
public IEnumerable <tbl_Languages> GetAll()
{
var lstData = HelperCache.GetCache <List <tbl_Languages> >(KeyCache);
if (lstData == null)
{
lstData = _entities.tbl_Languages.ToList();
HelperCache.AddCache(lstData, KeyCache);
}
return(lstData);
}
public void Edit(Video model)
{
HelperCache.RemoveCache(KeyCache);
object[] parameters =
{
new SqlParameter("@ID", model.ID),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Status", model.Status),
new SqlParameter("@Ordering", model.Ordering),
new SqlParameter("@IsShowPlay", model.IsShowPlay)
};
_entities.Database.ExecuteSqlCommand("Sp_Video_Update @ID,@Name,@Status,@Ordering,@IsShowPlay", parameters);
}
internal ILScanner(
DependencyAnalyzerBase <NodeFactory> dependencyGraph,
ILScanNodeFactory nodeFactory,
IEnumerable <ICompilationRootProvider> roots,
ILProvider ilProvider,
DebugInformationProvider debugInformationProvider,
Logger logger,
int parallelism)
: base(dependencyGraph, nodeFactory, roots, ilProvider, debugInformationProvider, null, nodeFactory.CompilationModuleGroup, logger)
{
_helperCache = new HelperCache(this);
_parallelism = parallelism;
}
public void Edit(Logo obj)
{
HelperCache.RemoveCache(KeyCache);
object[] parameters =
{
new SqlParameter("@ID", obj.ID),
new SqlParameter("@Name", obj.Name),
new SqlParameter("@Image", obj.Image),
new SqlParameter("@Type", obj.Type),
new SqlParameter("@Status", obj.Status)
};
_entities.Database.ExecuteSqlCommand("Sp_Logo_Update @ID,@Name,@Image,@Type,@Status", parameters);
}
internal ILScanner(
DependencyAnalyzerBase <NodeFactory> dependencyGraph,
ILScanNodeFactory nodeFactory,
IEnumerable <ICompilationRootProvider> roots,
ILProvider ilProvider,
DebugInformationProvider debugInformationProvider,
Logger logger,
bool singleThreaded)
: base(dependencyGraph, nodeFactory, roots, ilProvider, debugInformationProvider, null, logger)
{
_helperCache = new HelperCache(this);
_singleThreaded = singleThreaded;
}
public int AddOrder(tbl_Order model)
{
HelperCache.RemoveCache(KeyCache);
_entities.tbl_Order.Add(model);
_entities.SaveChanges();
return(model.ID);
//object[] parameters =
//{
// new SqlParameter("@CustomerName", model.CustomerName),
// new SqlParameter("@CustomerAddress",model.CustomerAddress),
// new SqlParameter("@CustomerPhone", model.CustomerPhone),
// new SqlParameter("@CustomerEmail", model.CustomerEmail),
// new SqlParameter("@Status",false)
//};
//_entities.Database.ExecuteSqlCommand("Sp_Order_Insert @CustomerName,@CustomerAddress,@CustomerPhone,@CustomerEmail,@Status", parameters);
}
public void Add(Video model)
{
HelperCache.RemoveCache(KeyCache);
object[] parameters =
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@Url", model.Url),
new SqlParameter("@Images", (object)model.Images ?? DBNull.Value),
new SqlParameter("@Status", model.Status),
new SqlParameter("@CreatedBy", model.CreatedBy),
new SqlParameter("@Type", model.Type),
new SqlParameter("@Ordering", model.Ordering),
new SqlParameter("@IsShowPlay", model.IsShowPlay)
};
_entities.Database.ExecuteSqlCommand("Sp_Video_Insert @Name,@Url,@Images,@Status,@CreatedBy,@Type,@Ordering,@IsShowPlay", parameters);
}
public void Edit(AdvImag model)
{
HelperCache.RemoveCache(KeyCache);
object[] parameters =
{
new SqlParameter("@ID", model.ID),
new SqlParameter("@Title", (object)model.Title ?? DBNull.Value),
new SqlParameter("@Image", model.Image),
new SqlParameter("@Link", (object)model.Link ?? DBNull.Value),
new SqlParameter("@Position", model.Position),
new SqlParameter("@Type", model.Type),
new SqlParameter("@TagetBlank", model.TagetBlank),
new SqlParameter("@DisplayOrder", model.DisplayOrder),
new SqlParameter("@Status", model.Status)
};
_entities.Database.ExecuteSqlCommand("Sp_Adv_Image_Update @ID,@Title,@Image,@Link,@Position,@Type,@TagetBlank,@DisplayOrder,@Status", parameters);
}
public ActionResult Delete(int id)
{
try
{
logoRepository.Delete(id);
HelperCache.RemoveCache(Keycache);
return(Json(new
{
IsSuccess = true,
Messenger = "Xóa menu thành công",
}, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new
{
IsSuccess = false,
Messenger = string.Format("Xóa menu thất bại")
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Add(AdminMenu obj)
{
try
{
_adminMenuRepository.Add(obj);
HelperCache.RemoveCache(Keycache);
return(Json(new
{
IsSuccess = true,
Messenger = "Thêm mới menu thành công",
}, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new
{
IsSuccess = false,
Messenger = string.Format("Thêm mới menu thất bại")
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Add(Logo obj)
{
try
{
if (string.IsNullOrEmpty(obj.Image))
{
return(Json(new
{
IsSuccess = false,
Messenger = "Vui lòng thêm ảnh",
}, JsonRequestBehavior.AllowGet));
}
var logo = logoRepository.GetAll().FirstOrDefault(x => x.Name.Trim() == obj.Name.Trim());
if (logo != null)
{
return(Json(new
{
IsSuccess = false,
Messenger = "Tên logo đã tồn tại",
}, JsonRequestBehavior.AllowGet));
}
logoRepository.Add(obj);
HelperCache.RemoveCache(Keycache);
return(Json(new
{
IsSuccess = true,
Messenger = "Thêm mới thành công",
}, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new
{
IsSuccess = false,
Messenger = string.Format("Thêm mới thất bại")
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteAll(string lstid)
{
var arrid = lstid.Split(',');
var count = 0;
HelperCache.RemoveCache(Keycache);
foreach (var item in arrid)
{
try
{
_adminMenuRepository.Delete(Convert.ToInt32(item));
count++;
}
catch (Exception)
{
continue;
}
}
return(Json(new
{
Messenger = string.Format("Xóa thành công {0} menu", count),
}, JsonRequestBehavior.AllowGet));
}
public void Add(Logo obj)
{
HelperCache.RemoveCache(KeyCache);
_entities.Logoes.Add(obj);
_entities.SaveChanges();
}
public void Edit(Model.tbl_Gallery obj)
{
HelperCache.RemoveCache(KeyCache);
_entities.Entry(obj).State = EntityState.Modified;
_entities.SaveChanges();
}
public void Add(AdvImag obj)
{
HelperCache.RemoveCache(KeyCache);
_entities.AdvImags.Add(obj);
_entities.SaveChanges();
}
public void Add(Model.tbl_Gallery obj)
{
HelperCache.RemoveCache(KeyCache);
_entities.tbl_Gallery.Add(obj);
_entities.SaveChanges();
}
public ActionResult ClearAllCache()
{
HelperCache.ClearAllCache();
return(Json("clear successfull", JsonRequestBehavior.AllowGet));
}
public void Edit(AdminMenu obj)
{
HelperCache.RemoveCache(KeyCache);
_entities.Entry(obj).State = EntityState.Modified;
_entities.SaveChanges();
}
public void Add(AdminMenu obj)
{
HelperCache.RemoveCache(KeyCache);
_entities.AdminMenus.Add(obj);
_entities.SaveChanges();
}
