public List <PaymentOrderItem> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from o in FDIDB.Payments_Order
orderby o.ID descending
select new PaymentOrderItem
{
ID = o.ID,
OrderCode = o.OrderCode,
DateCreate = o.DateCreate,
Customername = string.IsNullOrEmpty(o.Shop_Orders.CustomerName) ? string.IsNullOrEmpty(o.Shop_Orders.CompanyName) ? o.Shop_Orders.CompanyName : "(Khách lẻ)" : "(Khách lẻ)",
Phonenumber = o.Shop_Orders.Mobile,
TotalPrice = o.TotalPrice,
Method = o.Payment_Method.Name,
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <WalletItem> GetListSimpleByRequest(HttpRequestBase httpRequest, int agencyId)
{
Request = new ParramRequest(httpRequest);
var query = from c in FDIDB.Wallets
where c.AgencyId == agencyId
orderby c.WalletCus descending
select new WalletItem
{
ID = c.ID,
CustomerID = c.CustomerID,
CustomerName = c.Customer.FullName,
Customerphone = c.Customer.Phone,
WalletCus = c.WalletCus,
WalletOrder = c.WalletOrder,
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <SupplierAmountProductItem> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from o in FDIDB.SupplierAmountProducts
where o.IsDelete == false
orderby o.AmountEstimate descending
select new SupplierAmountProductItem
{
ID = o.ID,
CategoryName = o.Category.Name,
AmountEstimate = o.AmountEstimate,
AmountPayed = o.AmountPayed,
SupplierName = o.DN_Supplier.Name,
PublicationDate = o.PublicationDate
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <SourceItem> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from o in FDIDB.Sources
where o.IsDeleted != true && o.IsShow == true
orderby o.ID descending
select new SourceItem
{
ID = o.ID,
Name = o.Name,
SupplierName = o.StorageProduct.DN_Supplier.Name,
Description = o.Description,
IsShow = o.IsShow,
Code = o.Code,
DateCreate = o.DateCreate,
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <ProduceItem> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from o in FDIDB.Produces
where o.Isdelete == false
orderby o.ID descending
select new ProduceItem()
{
ID = o.ID,
ProductId = o.ProductId,
Quantity = o.Quantity,
Status = (ProduceStatus)o.Status,
ProductName = o.Category.Name,
DateProduce = o.DateProduce
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <DiscountItem> GetListSimple(HttpRequestBase httpRequest, int AgencyId)
{
Request = new ParramRequest(httpRequest);
var query = from o in FDIDB.Discounts where o.AgencyID == AgencyId
orderby o.ID descending
select new DiscountItem
{
ID = o.ID,
DateEnd = o.DateEnd,
DateStart = o.DateStart,
IsActive = o.IsActive,
IsAll = o.IsAll,
Percent = o.Percent,
PriceE = o.PriceE,
PriceS = o.PriceS
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <StorageFreightWarehouseItem> GetListSimpleByRequestRecive(HttpRequestBase httpRequest, int agencyId)
{
Request = new ParramRequest(httpRequest);
var from = httpRequest["fromDate"];
var to = httpRequest["toDate"];
var fromDate = !string.IsNullOrEmpty(from) ? from.StringToDate().TotalSeconds() : 0;
var toDate = !string.IsNullOrEmpty(to) ? to.StringToDate().AddDays(1).TotalSeconds() : DateTime.Now.TotalSeconds();
var query = from o in FDIDB.StorageFreightWarehouses
where o.AgencyReceiveID == agencyId && o.DateCreated >= fromDate && o.DateCreated <= toDate &&
(!o.IsDelete.HasValue || o.IsDelete == false)
orderby o.ID descending
select new StorageFreightWarehouseItem()
{
ID = o.ID,
Code = o.Code,
TotalPrice = o.TotalPrice ?? 0,
Payment = o.Payment ?? 0,
DateCreated = o.DateCreated,
DateImport = o.DateImport,
UserID = o.UserID,
KeyGuid = o.keyreq,
AgencyReceiveID = o.AgencyReceiveID,
Note = o.Note,
IsActive = o.IsActive,
IsDelete = o.IsDelete,
Status = o.Status,
IsOrder = o.IsOrder,
UsernameActive = o.DN_Users1.UserName,
DateActive = o.DateActive,
UsernameCreate = o.DN_Users.UserName,
};
var status = httpRequest["IsDelete"];
if (!string.IsNullOrEmpty(status))
{
var tus = int.Parse(status);
query = query.Where(c => c.Status == tus);
}
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <CustomerPolicyAppIG4Item> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from o in FDIDB.Customer_Policy
where o.IsShow == true && (!o.IsDeleted.HasValue || o.IsDeleted == false)
orderby o.ID descending
select new CustomerPolicyAppIG4Item
{
ID = o.ID,
Name = o.Name.Trim(),
IsDeleted = o.IsDeleted,
IsShow = o.IsShow,
Number = o.Number,
//StageName = o.Stage.Name,
StartMoney = o.StartMoney,
EndMoney = o.EndMoney,
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <TotalProductToDayItem> GetListSimpleByRequest(HttpRequestBase httpRequest, decimal code, int productId)
{
Request = new ParramRequest(httpRequest);
var query = from o in FDIDB.TotalProductToDays
where o.ToDayCode == code && o.ProductId == productId
orderby o.ID descending
select new TotalProductToDayItem()
{
ID = o.ID,
Quantity = o.Quantity,
SupplierName = o.DN_Supplier.Name,
SupplierId = o.SupplierId,
ProductId = o.SupplierId,
ProductName = o.Category.Name,
Note = o.Note,
Status = o.Status
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <WardsItem> GetListbyRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from c in FDIDB.Wards
where c.IsDeleted != true && c.IsShow == true
orderby c.Name
select new WardsItem
{
ID = c.ID,
Name = c.Name,
DistrictID = c.DistrictID
};
var dis = httpRequest["districtId"];
if (!string.IsNullOrEmpty(dis))
{
var disId = int.Parse(dis);
query = query.Where(c => c.DistrictID == disId);
}
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <DistrictItem> GetListbyRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from c in FDIDB.System_District
where c.IsDeleted != true && c.IsShow == true
orderby c.Name
select new DistrictItem
{
ID = c.ID,
Name = c.Name,
CityID = c.CityID,
};
var city = httpRequest["CityID"];
if (!string.IsNullOrEmpty(city))
{
var cityId = int.Parse(city);
query = query.Where(c => c.CityID == cityId);
}
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <DNRequestWareHouseItem> GetListSimpleAllByRequest(HttpRequestBase httpRequest, int area)
{
Request = new ParramRequest(httpRequest);
var from = httpRequest["fromDate"];
var query = from o in FDIDB.DN_RequestWare
where (!o.IsDelete.HasValue || o.IsDelete == false) &&
o.AreaID == area
// && o.StorageProductID == 1
orderby o.Hour descending
select new DNRequestWareHouseItem
{
GID = o.GID,
ProductName = o.Category.Name,
Today = o.Today,
Hours = o.Hour,
DateUpdate = o.DateUpdate,
UserUpdate = o.UserUpdate,
Quantity = o.Quantity,
QuantityActive = o.QuantityActive,
//Usercreate = o.StorageWarehousing.DN_Users.LoweredUserName,
Date = o.Date,
};
if (!string.IsNullOrEmpty(from))
{
var fromDate = ConvertDate.TotalSeconds(ConvertUtil.ToDateTime(from));
query = query.Where(c => c.Today == fromDate);
}
var hours = httpRequest["hours"];
if (!string.IsNullOrEmpty(hours))
{
var h = int.Parse(hours);
query = query.Where(c => c.Hours == h);
}
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <WorkShopItem> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from c in FDIDB.P_Workshop
where (!c.IsDeleted.HasValue || c.IsDeleted == false)
orderby c.ID descending
select new WorkShopItem
{
ID = c.ID,
Name = c.Name,
Address = c.Address,
IsActive = c.IsActive,
CompanyName = c.Company.Name,
DateActive = c.DateActive,
UserName = c.DN_Users.UserName,
DateCreated = c.DateCreated,
Latitute = c.Latitute,
Longitude = c.Longitude,
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <CarItem> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from o in FDIDB.Cars
where o.IsDelete == false
orderby o.ID descending
select new CarItem()
{
ID = o.ID,
Quantity = o.Quantity,
Name = o.Name,
Address = o.Address,
CarType = o.CarType,
Latitude = o.Latitude,
Longitude = o.Longitude,
Phone = o.Phone,
UnitID = o.UnitID,
UnitName = o.DN_Unit.Name
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <TemplateDocumentItem> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var id = int.Parse(httpRequest["type_T"] ?? "0");
var query = from o in FDIDB.TemplateDocuments
where o.IsDelete != true && o.IsShow == true
orderby o.ID descending
select new TemplateDocumentItem
{
ID = o.ID,
Name = o.Name,
DateCreate = o.DateCreate,
Type = o.Type,
Description = o.Description,
};
if (id > 0)
{
query = query.Where(c => c.Type == id);
}
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <SaleCodeItem> GetListSimpleByRequestCode(HttpRequestBase httpRequest, int agencyId, int id)
{
Request = new ParramRequest(httpRequest);
var query = from c in FDIDB.SaleCodes
where c.SaleID == id
orderby c.ID descending
select new SaleCodeItem
{
ID = c.ID,
DateUser = c.DateUse,
IsUser = c.IsUse,
Code = c.Code,
};
var use = httpRequest["IsUser_"];
if (!string.IsNullOrEmpty(use))
{
var isUse = use != "0";
query = query.Where(c => c.IsUser == isUse);
}
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <CompanyItem> GetListSimpleByRequest(HttpRequestBase httpRequest)
{
Request = new ParramRequest(httpRequest);
var query = from c in FDIDB.Companies
where (!c.IsDeleted.HasValue || c.IsDeleted == false)
orderby c.ID descending
select new CompanyItem
{
ID = c.ID,
Name = c.Name,
Address = c.Address,
DateCreate = c.DateCreate,
DateUpdate = c.DateUpdate,
UserName = c.DN_Users.UserName,
NameRepresent = c.NameRepresent,
NumberBank = c.NumberBank,
TaxCode = c.TaxCode,
Bank = c.Bank,
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <WalletItem> GetListCustomerByRequest(HttpRequestBase httpRequest, int agencyId)
{
Request = new ParramRequest(httpRequest);
var from = httpRequest["fromDate"];
var to = httpRequest["toDate"];
var fromDate = !string.IsNullOrEmpty(from) ? from.StringToDecimal(0) : 0;
var toDate = !string.IsNullOrEmpty(from) ? to.StringToDecimal(1) : DateTime.Now.TotalSeconds();
var query = from c in FDIDB.Customers
where c.WalletCustomers.Any(x => x.DateCreate >= fromDate && x.DateCreate <= toDate)
orderby c.ID
select new WalletItem
{
ID = c.ID,
CustomerName = c.FullName,
Customerphone = c.Phone,
CashOut = c.Wallets.Sum(a => a.CashOutWallet),
WalletCus = c.Wallets.Sum(a => a.WalletCus),
WalletOrder = c.Wallets.Sum(a => a.WalletOrder),
Username = c.UserName
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
public List <DNSalesItem> GetListSimpleByRequest(HttpRequestBase httpRequest, int agencyId)
{
Request = new ParramRequest(httpRequest);
var query = from c in FDIDB.DN_Sale
where c.AgencyId == agencyId && (!c.IsDeleted.HasValue || c.IsDeleted == false) && c.IsShow == true
orderby c.ID descending
select new DNSalesItem
{
ID = c.ID,
Name = c.Name,
DateEnd = c.DateEnd,
DateStart = c.DateStart,
Price = c.Price,
Percent = c.Percent,
AgencyId = c.AgencyId,
Username = c.DN_Users.UserName,
IsAgency = c.IsAgency,
IsAll = c.IsAll,
QuantityCode = c.QuantityCode,
};
query = query.SelectByRequest(Request, ref TotalRecord);
return(query.ToList());
}
