public ModuleShopProductValueItem GetListValueByRequest(HttpRequestBase httpRequest, int agecncy, out decimal?total, out decimal?quantity) { Request = new ParramRequest(httpRequest); var isValue = httpRequest["IsValue"] ?? "1"; var query = (from o in FDIDB.sp_GetListInventoryValue(int.Parse(isValue), agecncy) orderby o.ID descending select new ShopProductValueItem { ID = o.ID, Name = o.Name, UnitName = o.Unitname, Quantity = o.slNhap, QuantityOut = o.slXuat, QuantityInv = o.tonkho }).ToList(); var model = new ModuleShopProductValueItem { ListItems = query.ToList(), }; //query = query.SelectByRequest(Request); //total = query.Sum(m => (m.Quantity - (m.QuantityOut ?? 0)) * m.Price); total = 0; quantity = query.Sum(m => m.QuantityInv); //query = query.SelectPageByRequest(Request, ref TotalRecord); return(model); }
public List <SuggestionsProduct> GetListAutoFull(string keword, int showLimit, int agencyId, int type = 1) { var name = FomatString.Slug(keword); var date = DateTime.Now; var query = FDIDB.AutoSelectProductFull(name, showLimit).Select(c => new SuggestionsProduct { ID = c.ID, IsCombo = 0, //name = "<span>Mã SP: <b>" + (c.CodeSku ?? "") + "</b> - BarCode: <b>" + (c.BarCode ?? "") + "</b>- SL: <b>" + (c.Quantity ?? 0) + "</b> - Màu: <b> " + (c.namecolor ?? "") + "</b> - Size: <b>" + (c.namesize ?? "") + "</b>" + "</span>", UrlImg = c.UrlImg ?? "/Content/Admin/images/auto-default.jpg", QuantityDay = c.QuantityDay, //Quantity = c.Quantity, DateS = date.ToString("yyyy-MM-dd"), DateE = date.AddMonths(c.QuantityDay ?? 0).ToString("yyyy-MM-dd"), code = c.CodeSku, data = c.PriceNew.ToString(), title = c.Name, //PriceCost = c.PriceCost, pricenew = (decimal)c.PriceNew, Type = type }); return(query.ToList()); }
public BarcodeSouceItem GetByBarcode(string barcode, int cusId) { var query = from o in FDIDB.GetBySouceByBarcode(barcode, cusId) select new BarcodeSouceItem { GID = o.GID, BarCode = o.BarCode, NameAgency = o.NameAgency, AddressAgency = o.AddressAgency, PhoneAgency = o.PhoneAgency, Price = o.Price, PriceNew = o.PriceNew, IDStorage = o.IDStorage, NameSupplier = o.NameSupplier, AddressSupplier = o.AddressSupplier, Value = o.Value, IsCheck = o.Ischeck, FullName = o.FullName, UserName = o.UserName, CountSource1 = o.CountSource1, CountSource2 = o.CountSource2, CountSource3 = o.CountSource3, CountSource4 = o.CountSource4, DatePack = o.DatePack, DateImport = o.DateImport, DateOrder = o.DateOrder, Status = 1 }; return(query.FirstOrDefault()); }
public List <SuggestionsProduct> GetListAuto(string keword, int showLimit, int agencyId, int type = 1) { var name = FomatString.Slug(keword); var date = DateTime.Now; var query = FDIDB.AutoSelectProduct(name, showLimit).Select(c => new SuggestionsProduct { ID = c.ID, IdDetail = c.IdDetail, IsCombo = 0, name = "<span>BarCode: <b>" + (c.BarCode ?? "") + "</b>- SL: <b>" + (c.Quantity ?? 0) + "</b></span>", UrlImg = c.UrlImg ?? "/Content/Admin/images/auto-default.jpg", value = c.BarCode, BarCode = c.BarCode, QuantityDay = c.QuantityDay, Quantity = c.Quantity, DateS = date.ToString("yyyy-MM-dd"), DateE = date.AddMonths(c.QuantityDay ?? 0).ToString("yyyy-MM-dd"), data = c.PriceNew.ToString(), title = c.Name, pricenew = c.PriceNew, Type = type, }); return(query.ToList()); }
public List <SuggestionsProduct> GetListAutoOne(string keword, int showLimit, int agencyId, int type = 1) { var name = FomatString.Slug(keword); var query = FDIDB.AutoSelectProductOne(name, showLimit, agencyId).Select(c => new SuggestionsProduct { ID = c.ID, IsCombo = 0, name = "<span>BarCode: <b>" + (c.BarCode ?? "") + "</b>" + "</span>", UrlImg = c.UrlImg ?? "/Content/Admin/images/auto-default.jpg", value = c.BarCode, data = c.PriceNew.ToString(), title = c.Name, PriceCost = c.Price, DateS = c.Date.DecimalToString("dd/MM/yyyy"), DateE = c.DateEnd.DecimalToString("dd/MM/yyyy"), Quantity = 1, pricenew = c.PriceNew, Type = type, Idimport = c.IdImport, BarCode = c.BarCode, Valueweight = c.Value }).ToList(); return(query.ToList()); }
public AnalysisItem GetAllAnalysis(int agencyid, decimal start, decimal end) { var query = from c in FDIDB.GetAllAnalysis(agencyid, start, end) select new AnalysisItem { CountC = c.CountC, Later = c.Later, CountO = c.CountO, Cancelled = c.Cancelled, CashAdvance = c.CashAdvance, Complete = c.Complete, CountU = c.CountU, Onl = c.Onl, Payment = c.Payment, Pending = c.Pending, PriceReceive = c.PriceReceive, PriceReward = c.PriceReward, Processing = c.Processing, Receipt = c.Receipt, Refunded = c.Refunded, Repay = c.Repay, }; return(query.FirstOrDefault()); }
public List <CategoryItem> GetChildByParentId(bool setTitle) { var cate = from c in FDIDB.Category_GetList(LanguageId) select new CategoryItem { ID = c.Id, ParentId = c.ParentId, Name = c.Name, Slug = c.NameRoot, Type = c.Type, IsLevel = c.IsLevel, Price = c.Price, PriceRecipeFinal = c.PriceRecipeFinal, PriceFinal = c.PriceFinal, PercentLoss = c.PercentLoss, WeightDefault = c.WeightDefault, }; var re = cate.ToList(); if (setTitle) { re.Insert(0, new CategoryItem { ID = 0, Name = "-- Chọn chuyên mục --" }); } return(re); }
public List <DNAgencyAppItem> ListAgencyByKm(double x, double y, int id, int aid, int km) { var date = DateTime.Now.TotalSeconds(); if (aid > 0) { var query1 = from c in FDIDB.DN_Agency where c.ID == aid select new DNAgencyAppItem { ID = c.ID, Name = c.Name, Latitute = c.Latitute, Longitude = c.Longitude, Address = c.Address, }; return(query1.ToList()); } var query = from c in FDIDB.ListAgencyByKm(km, x, y, id, date) select new DNAgencyAppItem { ID = c.ID, Name = c.Name, Latitute = c.Latitute, Longitude = c.Longitude, Address = c.Address, Km = c.Km }; return(query.ToList()); }
public List <CategoryAppIG4Item> GetChildByParentId(bool setTitle, int type = 0) { var cate = from c in FDIDB.Category_GetList(LanguageId) select new CategoryAppIG4Item { ID = c.Id, ParentId = c.ParentId, Name = c.Name, Slug = c.NameRoot, Type = c.Type, IsLevel = c.IsLevel }; if (type != 0) { cate = cate.Where(c => c.Type == type); } var re = cate.ToList(); if (setTitle) { re.Insert(0, new CategoryAppIG4Item { ID = 0, Name = "-- Chọn chuyên mục --" }); } return(re); }
public List <AnalysisItem> AnalysisByEnterprise(int enterpriseId, decimal start, decimal end) { var query = from c in FDIDB.AnalysisByEnterprise(enterpriseId, start, end) select new AnalysisItem { CountC = c.CountC, Later = c.Later, CountO = c.CountO, Cancelled = c.Cancelled, CashAdvance = c.CashAdvance, Complete = c.Complete, CountU = c.CountU, Onl = c.Onl, Payment = c.Payment, Pending = c.Pending, PriceReceive = c.PriceReceive, PriceReward = c.PriceReward, Processing = c.Processing, Receipt = c.Receipt, Refunded = c.Refunded, Repay = c.Repay, }; return(query.ToList()); }
public void Delete(Customer customer) { customer.IsDelete = true; FDIDB.Customers.Attach(customer); var entry = FDIDB.Entry(customer); entry.Property(e => e.IsDelete).IsModified = true; // DB.Customers.Remove(customer); }
/// <summary> /// Insert Log /// </summary> /// <param name="productId"></param> /// <param name="userEdited"></param> /// <param name="propertiesChanged"></param> /// <param name="oldValue"></param> /// <param name="newValue"></param> /// <param name="actionTable"></param> //public void InsertLog(int productId, string userEdited, string propertiesChanged, string oldValue, string newValue, string actionTable) //{ // try // { // var logProduct = new Log_Shop_Product() // { // ProductId = productId, // UserEdited = userEdited, // PropertiesChanged = propertiesChanged, // OldValue = oldValue, // NewValue = newValue, // DateChanged = DateTime.Now, // TypeActionName = actionTable // }; // FDIDB.Log_Shop_Product.Add(logProduct); // Save(); // } // catch (Exception) // { // throw; // } //} /// <summary> /// Nghiatc2. /// </summary> /// <returns></returns> public void Save() { try { FDIDB.SaveChanges(); } catch (Exception) { } }
public List <ListChartAppIG4Item> GetStaticBarcharCustomerInMonth(int month) { var query = from c in FDIDB.StaticChartsCustomer(month) select new ListChartAppIG4Item { I = c.I, TotalCus = c.Total }; return(query.ToList()); }
public List <StaticWalletsTotal> GetStaticChartsTotalDay(int id, decimal fo, decimal to, int type) { var query = from c in FDIDB.StaticChartsbyDayAgencyTotalPrice(fo, to, id, type) select new StaticWalletsTotal { Total = c.Total ?? 0, DateCreate = c.DateCreate }; return(query.ToList()); }
public List <ListChartPacketAppIG4Item> GetStaticCustomerbuyPacketInMonth(int month) { var query = from c in FDIDB.StaticChartsCustomerBuyPacket(month) select new ListChartPacketAppIG4Item { I = c.I, Total = c.Total ?? 0 }; return(query.ToList()); }
public List <StaticDocumentItem> GeneralListStatic(int year, int areaId) { var query = FDIDB.StaticDocumentYear(year, areaId).Select(m => new StaticDocumentItem { Month = m.I ?? 0, TotalDoc = m.totadocument, TotalValue = m.totalvalue, TotalDeposit = m.totaldep }).ToList(); return(query); }
public List <TopCustomerStaticAppIG4> Top100CustomerSell(int page, int take) { var query = from c in FDIDB.Top100CustomerSell() select new TopCustomerStaticAppIG4 { Fullname = c.FullName, Email = c.Email, Total = c.total, }; return(query.Skip((page - 1) * take).Take(take).ToList()); }
public void AddTagToProduct(int tagId, int productId) { var product = FDIDB.Shop_Product.Find(productId); var tag = FDIDB.System_Tag.Find(tagId); if (product == null || tag == null) { return; } //product.System_Tag.Add(tag); FDIDB.SaveChanges(); }
public List <SysPageItem> GetChildByParentId(int parentId, int moduleType, int root, int agencyId) { var query = from c in FDIDB.SysPage_GetChildByParent(parentId, moduleType, root, agencyId) select new SysPageItem { ID = c.Id, ParentId = c.ParentId, Layout = c.Layout, Name = c.Symbol + c.Name }; return(query.ToList()); }
public List <ModuleItem> DNModule_GetChildByParentId(int parentID, int agencyid) { var query = from c in FDIDB.DNModule_GetChildByParentId(parentID, agencyid, true) select new ModuleItem { ID = c.Id.Value, NameModule = c.Name, Tag = c.Link, PrarentID = c.Parent, }; return(query.ToList()); }
public List <AttributeDynamicItem> GetAttribute(string lstInts, int id) { var query = from c in FDIDB.GetAttribute(lstInts, id) select new AttributeDynamicItem { ID = c.AttributeID, ProductId = c.ProductId, Name = c.Name, Value = c.Values }; return(query.ToList()); }
//public List<ProductAppIG4Item> ProductGetOrderShop(int cateid, int shopid, bool IsAll, decimal dates, decimal datee, int page, int pagesize) //{ // var query = FDIDB.ProductGetOrderShop(cateid, shopid, IsAll, dates, datee, page, pagesize).Select(m => // new ProductAppIG4Item // { // ID = m.ID, // Name = m.Name, // PriceNew = m.PriceNew ?? 0, // DateCreated = m.DateCreated, // Quantity = m.Quantity, // UrlPicture = m.Folder + m.Url, // }); // return query.ToList(); //} public List <DashboardItem> GroupProductGetOrderShop(int shopid, bool IsAll, decimal dates, decimal datee, int cateId) { var query = FDIDB.GroupProductGetOrderShop(shopid, IsAll, dates, datee, cateId).Select(m => new DashboardItem { CategoryId = m.id, Name = m.name, TotalPrice = m.totalprice, totalquantity = m.totalproduct, }); return(query.ToList()); }
public List <DNTreeItem> GetListParent(int agencyId) { var query = from o in FDIDB.GetListTree(agencyId) select new DNTreeItem { ID = o.Id, Level = o.Level, Name = o.Symbol + o.NameRoot, UserName = o.UserName }; return(query.ToList()); }
public List <GeneralTotalItem> GeneralListTotal(int year, int agencyId) { var query = FDIDB.GeneralYear(year, agencyId).Select(m => new GeneralTotalItem { Month = m.I ?? 0, TotalOrder = m.TotalPriceO ?? 0, TotalCash = m.TotalPriceCA ?? 0, TotalPayment = m.TotalPricePV ?? 0, TotalReceipt = m.TotalPriceRV ?? 0, TotalRepay = m.TotalPriceR ?? 0, }).ToList(); return(query); }
public StaticWalletsTotal GetStaticChartsTotal(int id, decimal fo, decimal to) { var query = from c in FDIDB.StaticChartsAgencyTotalPrice(fo, to, id) select new StaticWalletsTotal { Total = c.Total ?? 0, TotalCustomer = c.totalcustomer ?? 0, TotalAgency = c.totalagency ?? 0, TotalSouce = c.totalsouce ?? 0, Percent = ((c.Total - c.TotalOld) * c.TotalOld / 100) ?? 0 }; return(query.FirstOrDefault()); }
public IList <OrderDetailProductItem> GetSummary(decimal todayCode) { return(FDIDB.sp_GetOrderDetail(todayCode).Select(m => new OrderDetailProductItem() { ProductId = m.ProductDetailID, ProductName = m.Name, Quantity = m.Quantity ?? 0, CateID = m.CateID, CategoryName = m.CateName, SizeId = m.SizeID ?? 0, UnitName = m.UnitName, UnitValue = m.UnitValue ?? 0 }).ToList()); }
public List <ProductAppIG4Item> ProductGetbyShop(int cateid, int shopid, bool IsAll, DateTime dates, DateTime datee, int page, int pagesize) { var query = FDIDB.ProductGetbyShop(cateid, shopid, IsAll, dates.TotalSeconds(), datee.TotalSeconds(), page, pagesize).Select(m => new ProductAppIG4Item { ID = m.ID, Name = m.Name, PriceNew = m.PriceNew ?? 0, DateCreated = m.DateCreated, Quantity = m.Quantity, UrlPicture = m.Folder + m.Url, }); return(query.ToList()); }
public List <HtmlItem> GetList(int id = 0) { var query = from c in FDIDB.GetListHtml(id, LanguageId) select new HtmlItem { ID = c.ID, CtrId = c.ctrId, Sort = c.Sort ?? 0, PageId = c.PageID ?? 0, Name = c.Name, Section = c.Section }; return(query.ToList()); }
public System_Tag AddOrGet(string tagName) { var systemTag = GetByName(tagName); if (systemTag == null) { var newTag = new System_Tag { Name = tagName }; FDIDB.System_Tag.Add(newTag); FDIDB.SaveChanges(); return(newTag); } return(systemTag); }
public List <NewsAppIG4Item> StatisticsByActive(HttpRequestBase httpRequest) { var now = DateTime.Now; var str = httpRequest["fromdate"]; var end = httpRequest["todate"]; var startdate = !string.IsNullOrEmpty(str) ? str.StringToDate() : new DateTime(now.Year, now.Month, 1); var endDate = !string.IsNullOrEmpty(end) ? end.StringToDate().AddDays(1) : now; var query = from c in FDIDB.sp_thongkenguoiduyet(startdate, endDate) select new NewsAppIG4Item { UserActive = c.UserActive, Quantity = c.Quantity }; return(query.ToList()); }