public ActionResult NeverLogin(int? page, string searchTerm = null)
{
int pageNumber = (page ?? 1);
var auditorList = _context.Users.OrderByDescending(s => s.LastLogin).
Where(
p =>
(searchTerm == null || p.UserName.StartsWith(searchTerm)) &&
(p.LastLogin.Equals(p.OsysDateTime)));
var indexViewModel = new List<UserReportModel1>();
foreach (var n in auditorList)
{
if (n.Status == MyEnums.StatusOptions.Approved)
{
var model = new UserReportModel1
{
Fullnames = n.FirstName +' '+ n.LastName,
Username = n.UserName,
CreatedOn = n.OsysDateTime,
Email = n.Email,
PhoneNumber = n.PhoneNumber,
Country = n.Country,
Enabled = n.Enabled,
StatusOptions = true
};
indexViewModel.Add(model);
}
else
{
var model = new UserReportModel1
{
Fullnames = n.FirstName +' '+ n.LastName,
Username = n.UserName,
CreatedOn = n.OsysDateTime,
Email = n.Email,
PhoneNumber = n.PhoneNumber,
Country = n.Country,
Enabled = n.Enabled,
StatusOptions = false
};
indexViewModel.Add(model);
}
}
_getVals.LogAudit(User.Identity.GetUserName(), "Viewed", Request.UserHostName, "Viewed Last Login Report ",
"ISA", "UserManagement");
return View(indexViewModel.ToPagedList(pageNumber, pageSize));
}
public PartialViewResult SelectSalesOrder(int? page, string searchOrderNo, string searchCustomer, string searchEmail)
{
bool bStatus = false;
int pageIndex = 0;
int pageSize = PageSize;
int nHas = 0;
Customers customer = null;
SalesOrder salesorder = null;
IQueryable<SalesOrder> qrySalesOrder = null;
IQueryable<CustomersContactAddress> qryAddress = null;
List<int> customerIdsList = new List<int>();
List<SalesOrder> SalesOrderList = new List<SalesOrder>();
if (string.IsNullOrEmpty(searchOrderNo) && string.IsNullOrEmpty(searchCustomer) && string.IsNullOrEmpty(searchEmail))
{
qrySalesOrder = db.SalesOrders.OrderBy(slor => slor.SalesOrderNo);
if (qrySalesOrder.Count() > 0)
{
foreach (var item in qrySalesOrder)
{
bStatus = VerifyInvoiceSalesOrder(item);
if (bStatus == false)
{
SalesOrderList.Add(item);
}
}
}
}
else
{
if (!string.IsNullOrEmpty(searchEmail))
{
ViewBag.SearchEmail = searchEmail;
qryAddress = db.CustomersContactAddresses.Where(ctad => ctad.Email.StartsWith(searchEmail));
if (qryAddress.Count() > 0)
{
foreach (var item in qryAddress)
{
nHas = Convert.ToInt32(item.CustomerId);
if (nHas > 0)
{
customerIdsList.Add(nHas);
}
}
}
}
if (!string.IsNullOrEmpty(searchCustomer))
{
ViewBag.SearchCustomer = searchCustomer;
qryAddress = db.CustomersContactAddresses.Where(ctad => ctad.CompanyName.StartsWith(searchCustomer));
if (qryAddress.Count() > 0)
{
foreach (var item in qryAddress)
{
nHas = Convert.ToInt32(item.CustomerId);
if (nHas > 0)
{
customerIdsList.Add(nHas);
}
}
}
}
if (customerIdsList.Count > 0)
{
foreach (var itemCustomer in customerIdsList)
{
qrySalesOrder = db.SalesOrders.Where(slor => slor.CustomerId == itemCustomer).OrderBy(slor => slor.SalesOrderNo);
if (qrySalesOrder.Count() > 0)
{
foreach (var item in qrySalesOrder)
{
SalesOrderList.Add(item);
}
}
}
}
if (!string.IsNullOrEmpty(searchOrderNo))
{
ViewBag.SearchOrderNo = searchOrderNo;
qrySalesOrder = db.SalesOrders.Where(slor => slor.SalesOrderNo.StartsWith(searchOrderNo)).OrderBy(slor => slor.SalesOrderNo);
if (qrySalesOrder.Count() > 0)
{
foreach (var item in qrySalesOrder)
{
SalesOrderList.Add(item);
}
}
}
}
//Set the page
if (page == null)
{
pageIndex = 1;
}
else
{
pageIndex = Convert.ToInt32(page);
}
var onePageOfData = SalesOrderList.ToPagedList(pageIndex, pageSize);
ViewBag.OnePageOfData = onePageOfData;
return PartialView(SalesOrderList.ToPagedList(pageIndex, pageSize));
}
public ActionResult LastLogin(int? page, string searchTerm = null)
{
int pageNumber = (page ?? 1);
var auditorList = _context.Users.OrderByDescending(s => s.LastLogin).
Where(p => searchTerm == null || p.UserName.StartsWith(searchTerm));
var indexViewModel = new List<UserReportModel>();
foreach (var n in auditorList)
{
var mygroup = _repository.Find<Group>(n.GroupId);
//var days = n.LastLogin.Subtract(DateTime.Now).Days;
var days = DateTime.Now.Subtract(n.LastLogin).Days;
var model = new UserReportModel
{
Fullnames = n.FirstName +' '+ n.LastName,
Username = n.UserName,
Lastlogin = n.LastLogin,
DaysLastLogin = days,
Enabled = n.Enabled,
StatusOptions = n.Status
};
indexViewModel.Add(model);
}
_getVals.LogAudit(User.Identity.GetUserName(), "Viewed", Request.UserHostName, "Viewed Last Login Report ",
"ISA", "UserManagement");
return View(indexViewModel.ToPagedList(pageNumber, pageSize));
}
public PartialViewResult InvoiceList(int? page)
{
int pageIndex = 0;
int pageSize = PageSize;
TimelyDepotContext db01 = new TimelyDepotContext();
InvoiceList theinvoicelist = null;
List<InvoiceList> invoiceList = new List<InvoiceList>();
var qrySalesOrder = db.CustomersContactAddresses.Join(db.Invoices, ctad => ctad.CustomerId, slod => slod.CustomerId, (ctad, slod)
=> new { ctad, slod }).OrderBy(cact => cact.slod.SalesOrderId);
if (qrySalesOrder.Count() > 0)
{
foreach (var item in qrySalesOrder)
{
theinvoicelist = new InvoiceList();
theinvoicelist.InvoiceId = item.slod.InvoiceId;
theinvoicelist.InvoiceNo = item.slod.InvoiceNo;
theinvoicelist.SODate = item.slod.ShipDate;
theinvoicelist.CustomerNo = GetCustomerDataInvoice(db01, item.ctad.CustomerId.ToString());
theinvoicelist.CompanyName = item.ctad.CompanyName;
theinvoicelist.PurchaseOrderNo = item.slod.PurchaseOrderNo;
theinvoicelist.SalesOrderNo = item.slod.SalesOrderNo;
theinvoicelist.PaymentAmount = GetInvoiceAmount(db01, item.slod.InvoiceId);
invoiceList.Add(theinvoicelist);
}
}
//Set the page
if (page == null)
{
pageIndex = 1;
}
else
{
pageIndex = Convert.ToInt32(page);
}
var onePageOfData = invoiceList.ToPagedList(pageIndex, pageSize);
ViewBag.OnePageOfData = onePageOfData;
return PartialView(invoiceList.ToPagedList(pageIndex, pageSize));
}
//
// GET: /Invoice/
public ActionResult Index(int? page, string searchItem, string ckActive, string ckCriteria)
{
bool bHasData = true;
int nYear = 0;
int nMonth = 0;
int nDay = 0;
int pageIndex = 0;
int pageSize = PageSize;
string[] szFecha = null;
DateTime dFecha = DateTime.Now;
IQueryable<Invoice> qryInvoice = null;
List<Invoice> InvoiceList = new List<Invoice>();
if (string.IsNullOrEmpty(searchItem) || searchItem == "0")
{
//qryItem = db.ITEMs.OrderBy(it => it.ItemID);
ViewBag.ckActiveHlp = "true";
ViewBag.ckCriteriaHlp = "invoice";
ViewBag.CurrentDate = dFecha.ToString("yyyy/MM/dd");
bHasData = false;
if (searchItem == "0")
{
ViewBag.SearchItem = searchItem;
bHasData = true;
if (ckCriteria == "invoice")
{
if (ckActive == "true")
{
qryInvoice = db.Invoices.OrderBy(vd => vd.InvoiceNo);
}
else
{
qryInvoice = db.Invoices.OrderBy(vd => vd.InvoiceNo);
}
}
}
}
else
{
ViewBag.SearchItem = searchItem;
ViewBag.ckActiveHlp = ckActive;
ViewBag.ckCriteriaHlp = ckCriteria;
if (ckCriteria == "invoice")
{
if (ckActive == "true")
{
qryInvoice = db.Invoices.Where(vd => vd.InvoiceNo.StartsWith(searchItem)).OrderBy(vd => vd.InvoiceNo);
}
else
{
qryInvoice = db.Invoices.Where(vd => vd.InvoiceNo.StartsWith(searchItem)).OrderBy(vd => vd.InvoiceNo);
}
}
if (ckCriteria == "salesorder")
{
if (ckActive == "true")
{
qryInvoice = db.Invoices.Where(vd => vd.SalesOrderNo.StartsWith(searchItem)).OrderBy(vd => vd.SalesOrderNo);
}
else
{
qryInvoice = db.Invoices.Where(vd => vd.SalesOrderNo.StartsWith(searchItem)).OrderBy(vd => vd.SalesOrderNo);
}
}
if (ckCriteria == "shippeddate")
{
szFecha = searchItem.Split('/');
if (szFecha != null)
{
nYear = Convert.ToInt32(szFecha[0]);
nMonth = Convert.ToInt32(szFecha[1]);
nDay = Convert.ToInt32(szFecha[2]);
dFecha = new DateTime(nYear, nMonth, nDay);
}
if (ckActive == "true")
{
qryInvoice = db.Invoices.Where(vd => vd.ShipDate >= dFecha).OrderBy(vd => vd.SalesOrderNo);
}
else
{
qryInvoice = db.Invoices.Where(vd => vd.ShipDate >= dFecha).OrderBy(vd => vd.SalesOrderNo);
}
}
if (ckCriteria == "customerpo")
{
if (ckActive == "true")
{
qryInvoice = db.Invoices.Where(vd => vd.PurchaseOrderNo.StartsWith(searchItem)).OrderBy(vd => vd.PurchaseOrderNo);
}
else
{
qryInvoice = db.Invoices.Where(vd => vd.PurchaseOrderNo.StartsWith(searchItem)).OrderBy(vd => vd.PurchaseOrderNo);
}
}
if (ckCriteria == "customername")
{
if (ckActive == "true")
{
var qryMainContact = db.Invoices.Join(db.CustomersContactAddresses, ctc => ctc.CustomerId, cus => cus.CustomerId, (ctc, cus)
=> new { ctc, cus }).Where(Nctcs => Nctcs.cus.CompanyName.StartsWith(searchItem)).OrderBy(Nctcs => Nctcs.cus.CompanyName);
if (qryMainContact.Count() > 0)
{
foreach (var item in qryMainContact)
{
InvoiceList.Add(item.ctc);
}
}
}
else
{
var qryMainContact = db.Invoices.Join(db.CustomersContactAddresses, ctc => ctc.CustomerId, cus => cus.CustomerId, (ctc, cus)
=> new { ctc, cus }).Where(Nctcs => Nctcs.cus.CompanyName.StartsWith(searchItem)).OrderBy(Nctcs => Nctcs.cus.CompanyName);
if (qryMainContact.Count() > 0)
{
foreach (var item in qryMainContact)
{
InvoiceList.Add(item.ctc);
}
}
}
bHasData = false;
}
}
if (bHasData)
{
if (qryInvoice != null)
{
if (qryInvoice.Count() > 0)
{
foreach (var item in qryInvoice)
{
InvoiceList.Add(item);
}
}
}
}
//Set the page
if (page == null)
{
pageIndex = 1;
}
else
{
pageIndex = Convert.ToInt32(page);
}
var onePageOfData = InvoiceList.ToPagedList(pageIndex, pageSize);
ViewBag.OnePageOfData = onePageOfData;
return View(InvoiceList.ToPagedList(pageIndex, pageSize));
//return View(db.Invoices.ToList());
}
public PartialViewResult GetSalesDetailsSRC(int? page, string salesorderid)
{
TimelyDepotContext db01 = new TimelyDepotContext();
int pageIndex = 0;
int pageSize = PageSize;
pageSize = 10;
int nSalesOrderid = Convert.ToInt32(salesorderid);
string szSalesOredidHlp = "";
string szShipped = "";
IQueryable<InvoiceDetail> qrysalesdetails = null;
IQueryable<ImprintMethods> qryImprint = null;
InvoiceDetail setupcharge = null;
InvoiceDetail runcharge = null;
InvoiceDetailSRC salesorderdetailSRC = null;
ShipmentDetails shipped = null;
List<InvoiceDetailSRC> salesdetailsList = new List<InvoiceDetailSRC>();
List<KeyValuePair<string, string>> listSelector = new List<KeyValuePair<string, string>>();
//qrysalesdetails = db.SalesOrderDetails.Where(sldt => sldt.SalesOrderId == nSalesOrderid).OrderBy(sldt => sldt.Sub_ItemID).ThenBy(sldt => sldt.ItemOrder);
qrysalesdetails = db.InvoiceDetails.Where(sldt => sldt.InvoiceId == nSalesOrderid && sldt.ItemID != "").OrderBy(sldt => sldt.ItemPosition).ThenBy(sldt => sldt.ItemOrder);
if (qrysalesdetails.Count() > 0)
{
foreach (var item in qrysalesdetails)
{
salesorderdetailSRC = new InvoiceDetailSRC();
salesorderdetailSRC.BackOrderQuantity = item.BackOrderQuantity;
salesorderdetailSRC.Description = item.Description;
salesorderdetailSRC.Id = item.Id;
salesorderdetailSRC.ImprintMethod = item.ImprintMethod;
salesorderdetailSRC.ItemID = item.ItemID;
salesorderdetailSRC.ItemOrder = item.ItemOrder;
salesorderdetailSRC.ItemPosition = item.ItemPosition;
salesorderdetailSRC.Logo = item.Logo;
salesorderdetailSRC.Quantity = item.Quantity;
salesorderdetailSRC.SalesOrderId = item.InvoiceId;
salesorderdetailSRC.ShipQuantity = item.ShipQuantity;
salesorderdetailSRC.Sub_ItemID = item.Sub_ItemID;
salesorderdetailSRC.Tax = item.Tax;
salesorderdetailSRC.UnitPrice = item.UnitPrice;
salesorderdetailSRC.QuantitySC = 0;
salesorderdetailSRC.UnitPricSRC = 0;
salesorderdetailSRC.QuantityRC = 0;
salesorderdetailSRC.UnitPriceRC = 0;
//Set Up Charge
szSalesOredidHlp = string.Format("Set up Charge {0} {1}", salesorderdetailSRC.SalesOrderId.ToString(), salesorderdetailSRC.ItemID);
setupcharge = db01.InvoiceDetails.Where(stup => stup.InvoiceId == item.InvoiceId && stup.Description == szSalesOredidHlp).FirstOrDefault<InvoiceDetail>();
if (setupcharge != null)
{
salesorderdetailSRC.QuantitySC = setupcharge.Quantity;
salesorderdetailSRC.UnitPricSRC = setupcharge.UnitPrice;
}
//Run Charge
szSalesOredidHlp = string.Format("Run Charge {0} {1}", salesorderdetailSRC.SalesOrderId.ToString(), salesorderdetailSRC.ItemID);
runcharge = db01.InvoiceDetails.Where(stup => stup.InvoiceId == item.InvoiceId && stup.Description == szSalesOredidHlp).FirstOrDefault<InvoiceDetail>();
if (runcharge != null)
{
salesorderdetailSRC.QuantityRC = runcharge.Quantity;
salesorderdetailSRC.UnitPriceRC = runcharge.UnitPrice;
}
salesdetailsList.Add(salesorderdetailSRC);
//Get the shipped items
shipped = db01.ShipmentDetails.Where(shpdtl => shpdtl.DetailId == item.Id).FirstOrDefault<ShipmentDetails>();
if (shipped != null)
{
if (string.IsNullOrEmpty(szShipped))
{
szShipped = string.Format("lkshiped_{0}", item.Id);
}
else
{
szShipped = string.Format("{0};lkshiped_{1}", szShipped ,item.Id);
}
}
}
}
ViewBag.SalesOrderId = salesorderid;
if (!string.IsNullOrEmpty(szShipped))
{
ViewBag.ShippedItems = szShipped;
}
//Get the imprint methods
qryImprint = db.ImprintMethods.OrderBy(trd => trd.Description);
if (qryImprint.Count() > 0)
{
foreach (var item in qryImprint)
{
listSelector.Add(new KeyValuePair<string, string>(item.Description, item.Description));
}
}
SelectList imprintlist = new SelectList(listSelector, "Key", "Value");
ViewBag.ImprintList = imprintlist;
//Set the page
if (page == null)
{
pageIndex = 1;
}
else
{
pageIndex = Convert.ToInt32(page);
}
var onePageOfData = salesdetailsList.ToPagedList(pageIndex, pageSize);
ViewBag.OnePageOfData = onePageOfData;
return PartialView(salesdetailsList.ToPagedList(pageIndex, pageSize));
}
public PartialViewResult GetSalesDetails(int? page, string salesorderid)
{
int pageIndex = 0;
int pageSize = PageSize;
pageSize = 10;
int nSalesOrderid = Convert.ToInt32(salesorderid);
IQueryable<InvoiceDetail> qrysalesdetails = null;
List<InvoiceDetail> salesdetailsList = new List<InvoiceDetail>();
//qrysalesdetails = db.SalesOrderDetails.Where(sldt => sldt.SalesOrderId == nSalesOrderid).OrderBy(sldt => sldt.Sub_ItemID).ThenBy(sldt => sldt.ItemOrder);
qrysalesdetails = db.InvoiceDetails.Where(sldt => sldt.InvoiceId == nSalesOrderid).OrderBy(sldt => sldt.ItemPosition).ThenBy(sldt => sldt.ItemOrder);
if (qrysalesdetails.Count() > 0)
{
foreach (var item in qrysalesdetails)
{
salesdetailsList.Add(item);
}
}
ViewBag.SalesOrderId = salesorderid;
//Set the page
if (page == null)
{
pageIndex = 1;
}
else
{
pageIndex = Convert.ToInt32(page);
}
var onePageOfData = salesdetailsList.ToPagedList(pageIndex, pageSize);
ViewBag.OnePageOfData = onePageOfData;
return PartialView(salesdetailsList.ToPagedList(pageIndex, pageSize));
}
public PartialViewResult AddDetail(string searchitem, string itemOrder, int? page, int salesorderid = 0, int itemPos = 0)
{
int pageIndex = 0;
int pageSize = PageSize;
pageSize = 15;
IQueryable<SUB_ITEM> qrysubitem = null;
List<SUB_ITEM> subitemList = new List<SUB_ITEM>();
if (string.IsNullOrEmpty(searchitem))
{
qrysubitem = db.SUB_ITEM.OrderBy(sbit => sbit.Sub_ItemID);
}
else
{
ViewBag.SearchItem = searchitem;
qrysubitem = db.SUB_ITEM.Where(sbit => sbit.Sub_ItemID.StartsWith(searchitem)).OrderBy(sbit => sbit.Sub_ItemID);
}
if (qrysubitem.Count() > 0)
{
foreach (var item in qrysubitem)
{
subitemList.Add(item);
}
}
ViewBag.SalesOrderId = salesorderid;
ViewBag.ItemPos = itemPos;
ViewBag.ItemOrder = itemOrder;
//Set the page
if (page == null)
{
pageIndex = 1;
}
else
{
pageIndex = Convert.ToInt32(page);
}
var onePageOfData = subitemList.ToPagedList(pageIndex, pageSize);
ViewBag.OnePageOfData = onePageOfData;
return PartialView(subitemList.ToPagedList(pageIndex, pageSize));
}