public ActionResult History(ImexFilter filter)
{
var model = new ImportList(filter);
model.List = SKtimeManagement.Import.History(UserID, Employee.ID, Employee.BussinessID, filter, true);
model.Current = new ImportRecord();
if (Request.IsAjaxRequest())
{
return(Json(new
{
result = true,
html = RenderPartialViewToString(Views.HistoryPartial, model)
}, JsonRequestBehavior.AllowGet));
}
return(View(Views.History, model));
}
public WarrantyModel(List <ExportRecord> orders = null, ImexFilter filter = null, Warranty model = null)
{
Filter = filter;
if (Filter == null)
{
Filter = new ImexFilter();
}
Record = model;
if (Record == null)
{
Record = new Warranty();
}
Orders = orders;
if (Orders == null)
{
Orders = new List <ExportRecord>();
}
}
public WarrantyModel(List <ProductInfo> products, ImexFilter filter = null, Warranty model = null)
{
Filter = filter;
if (Filter == null)
{
Filter = new ImexFilter();
}
Record = model;
if (Record == null)
{
Record = new Warranty();
}
Products = products;
if (Orders == null)
{
Orders = new List <ExportRecord>();
}
}
public RepairModel(List <ProductInfo> products = null, ImexFilter filter = null, Repair model = null)
{
Filter = filter;
if (Filter == null)
{
Filter = new ImexFilter();
}
Record = model;
if (Record == null)
{
Record = new Repair();
}
Products = products;
if (Products == null)
{
Products = new List <ProductInfo>();
}
}
public static List <ImportRecord> History(int userID, int employeeID, int bussinessID, ImexFilter filter = null, bool log = false)
{
QueryOutput queryResult;
var conditions = new List <string>();
if (filter != null)
{
if (filter.WarehouseID.HasValue)
{
conditions.Add(String.Format("and i.WarehouseID = {0}", filter.WarehouseID.DbValue()));
}
if (filter.EmployeeID.HasValue)
{
conditions.Add(String.Format("and i.EmployeeID = {0}", filter.EmployeeID.DbValue()));
}
if (!String.IsNullOrEmpty(filter.Code))
{
conditions.Add(String.Format("and i.Code like N'%{0}%'", filter.Code));
}
if (!String.IsNullOrEmpty(filter.Receipt))
{
conditions.Add(String.Format("and i.Receipt like N'%{0}%'", filter.Receipt));
}
if (filter.From.HasValue)
{
conditions.Add(String.Format("and i.SubmitDate >= '{0}'", filter.From.Value.ToString(Constants.DatabaseDatetimeString)));
}
if (filter.To.HasValue)
{
conditions.Add(String.Format("and i.SubmitDate <= '{0}'", filter.To.Value.ToString(Constants.DatabaseDatetimeString)));
}
}
return(Query <ImportRecord>(new DbQuery(userID, employeeID, DbAction.Import.View,
String.Format(
@"select top 100 i.*, e.Name as [EmployeeName], w.Name as [WarehouseName]
from Import i
join Warehouse w on i.WarehouseID = w.ID and w.Status = 'active' and ((select Username from Login where ID = {2}) = 'admin' or w.ID in (select WarehouseID from LoginWarehouse where LoginID = {2}))
join Employee e on i.EmployeeID = e.ID
where i.Status = 'active' and i.BussinessID = {0} {1} order by i.ID desc",
bussinessID, String.Join(" ", conditions), userID), log), out queryResult));
}
public ImportList(ImexFilter filter = null, string message = "")
{
List = new List <ImportRecord>();
Filter = filter != null ? filter : new ImexFilter();
Message = message;
}
public static List <ExportRecord> OrderHistory(int userID, int employeeID, int bussinessID, ImexFilter filter = null, bool log = false, string action = null)
{
if (String.IsNullOrEmpty(action))
{
action = DbAction.Order.View;
}
QueryOutput queryResult;
var conditions = new List <string>();
if (filter != null)
{
if (filter.FindUnpaid == "on")
{
conditions.Add(String.Format("and o.Total - o.Discount > o.Paid"));
}
if (filter.WarehouseID.HasValue)
{
conditions.Add(String.Format("and o.WarehouseID = {0}", filter.WarehouseID.DbValue()));
}
if (filter.EmployeeID.HasValue)
{
conditions.Add(String.Format("and o.EmployeeID = {0}", filter.EmployeeID.DbValue()));
}
if (filter.ClientID.HasValue)
{
conditions.Add(String.Format("and c.ID = {0}", filter.ClientID.DbValue()));
}
if (!String.IsNullOrEmpty(filter.ClientPhone))
{
conditions.Add(String.Format("and c.Phone like N'%{0}%'", filter.ClientPhone));
}
if (!String.IsNullOrEmpty(filter.Code))
{
conditions.Add(String.Format("and o.Code like N'%{0}%'", filter.Code));
}
if (!String.IsNullOrEmpty(filter.ExportCode))
{
conditions.Add(String.Format("and ex.Code like N'%{0}%'", filter.ExportCode));
}
if (filter.From.HasValue)
{
conditions.Add(String.Format("and o.SubmitDate >= '{0}'", filter.From.Value.ToString(Constants.DatabaseDatetimeString)));
}
if (filter.To.HasValue)
{
conditions.Add(String.Format("and o.SubmitDate <= '{0}'", filter.To.Value.ToString(Constants.DatabaseDatetimeString)));
}
if (filter.Returned == "on")
{
conditions.Add(String.Format("and o.Returned = 1"));
}
}
return(Query <ExportRecord>(new DbQuery(userID, employeeID, action,
String.Format(@"select top 100 o.ID, o.EmployeeID, o.DeliveryID, o.WarehouseID, o.Code, o.SubmitDate, o.PayMethod, o.Receipt, o.Total, o.Discount, o.Paid, o.Note, o.Status, o.Returned,
w.Name as [WarehouseName], c.ID as [ClientID], c.Name as [ClientName], em.Name as [EmployeeName], del.Name as [DeliveryName], ex.ID as [ExportID], ex.Code as [ExportCode]
from SKtimeManagement..[Order] o
join Warehouse w on o.WarehouseID = w.ID and w.Status = 'active' and ((select Username from Login where ID = {2}) = 'admin' or w.ID in (select WarehouseID from LoginWarehouse where LoginID = {2}))
join ExportProduct p on o.ID = p.OrderID and p.Returned = 0
left join Export ex on ex.ID = p.ExportID
join Employee em on o.EmployeeID = em.ID
left join Delivery del on o.DeliveryID = del.ID
left join Client c on o.ClientID = c.ID
where o.Removed = 0 and o.BussinessID = {0} {1}
group by o.ID, o.EmployeeID, o.DeliveryID, o.WarehouseID, o.Code, o.SubmitDate, o.PayMethod, o.Receipt, o.Total, o.Discount, o.Paid, o.Note, o.Status, o.Returned,
w.Name, c.ID, c.Name, em.Name, del.Name, ex.ID, ex.Code
order by o.SubmitDate desc", bussinessID, String.Join(" ", conditions), userID), log), out queryResult));
}
public static List <ExportRecord> History(int userID, int employeeID, int bussinessID, ImexFilter filter = null, bool log = false)
{
QueryOutput queryResult;
var conditions = new List <string>();
if (filter != null)
{
if (filter.WarehouseID.HasValue)
{
conditions.Add(String.Format("and e.WarehouseID = {0}", filter.WarehouseID.DbValue()));
}
if (filter.EmployeeID.HasValue)
{
conditions.Add(String.Format("and e.EmployeeID = {0}", filter.EmployeeID.DbValue()));
}
if (filter.ClientID.HasValue)
{
conditions.Add(String.Format("and c.ID = {0}", filter.ClientID.DbValue()));
}
if (!String.IsNullOrEmpty(filter.Code))
{
conditions.Add(String.Format("and e.Code like N'%{0}%'", filter.Code));
}
if (!String.IsNullOrEmpty(filter.OrderCode))
{
conditions.Add(String.Format("and o.Code like N'%{0}%'", filter.OrderCode));
}
if (filter.From.HasValue)
{
conditions.Add(String.Format("and e.SubmitDate >= '{0}'", filter.From.Value.ToString(Constants.DatabaseDatetimeString)));
}
if (filter.To.HasValue)
{
conditions.Add(String.Format("and e.SubmitDate <= '{0}'", filter.To.Value.ToString(Constants.DatabaseDatetimeString)));
}
}
return(Query <ExportRecord>(new DbQuery(userID, employeeID, DbAction.Export.View,
String.Format(@"select top 100 e.ID, e.EmployeeID, e.BussinessID, e.WarehouseID, e.Code, e.SubmitDate, e.Note, e.Status, e.ToWarehouseID, tw.Name as [ToWarehouseName], w.Name as [WarehouseName], c.ID as [ClientID], c.Name as [ClientName], o.ID as [OrderID], o.Code as [OrderCode], em.Name as [EmployeeName]
from Export e
join Warehouse w on e.WarehouseID = w.ID and w.Status = 'active' and ((select Username from Login where ID = {2}) = 'admin' or w.ID in (select WarehouseID from LoginWarehouse where LoginID = {2}))
join Employee em on e.EmployeeID = em.ID
join ExportProduct p on e.ID = p.ExportID and p.Returned = 0
left join SKtimeManagement..[Order] o on p.OrderID = o.ID
left join Client c on o.ClientID = c.ID
left join Warehouse tw on e.ToWarehouseID = tw.ID and tw.Status = 'active'
where e.Removed = 0 and p.OrderID is null and p.ExportID is not null and e.BussinessID = {0} {1}
group by e.ID, e.EmployeeID, e.BussinessID, e.WarehouseID, e.Code, e.SubmitDate, e.Note, e.Status, e.ToWarehouseID, tw.Name, w.Name, c.ID, c.Name, o.ID, o.Code, em.Name
order by e.ID desc", bussinessID, String.Join(" ", conditions), userID), log), out queryResult));
}
public ExportList(ImexFilter filter = null)
{
List = new List <ExportRecord>();
Filter = filter != null ? filter : new ImexFilter();
}
