public ActionResult CheckExpiry()
{
using (ASITPOSDBEntities db = new ASITPOSDBEntities())
{
var list = db.Stocks.SqlQuery("select * from Stock s where s.ExpiryDate - GETDATE() < 75").ToList();
return Json(list.Count(), JsonRequestBehavior.AllowGet);
}
}
public ActionResult StockLevel()
{
using (ASITPOSDBEntities db = new ASITPOSDBEntities())
{
var list = db.Stocks.SqlQuery("select * from dbo.Stock s, dbo.Item i where i.ItemID = s.ItemID and s.Qty<i.AlertQty and s.Qty>0").ToList();
return Json(list.Count(), JsonRequestBehavior.AllowGet);
}
}
public void InsertOrUpdateInventory(PurchaseItem vm)
{
using (ASITPOSDBEntities db = new ASITPOSDBEntities())
{
_stock = new Stock();
//Initialize new stock with vm inserted values
_stock.ItemID = vm.ItemID;
_stock.BatchNo = vm.Batch;
_stock.CostPrice = vm.CostPrice;
_stock.SellingPrice = vm.SellingPrice;
_stock.ExpiryDate = vm.Expiry;
_stock.PurchaseID = vm.PurchaseID;
//Get list of all the inserted item in Stock table
List <Stock> _checkItem = (from s in db.Stocks
where s.ItemID == vm.ItemID && s.BatchNo == vm.Batch
select s).ToList();
//count the number of exixting record on inserted item
int countStock = _checkItem.Count();
//Add new record if record is not found
if (countStock == 0)
{
//Add new item with new Initial qty
_stock.Qty = vm.Qty;
_stock.InitialQty = _stock.Qty;
db.Stocks.Add(_stock);
db.SaveChanges();
}
else
{
//to check how many times loop executes completely
int loopCount = 0;
//Check and Add or update
foreach (Stock stock in _checkItem)
{
if (stock.CostPrice == vm.CostPrice)
{
//Update qty and InitialQty
stock.Qty += vm.Qty;
stock.InitialQty += vm.Qty;
db.SaveChanges();
break;
}
loopCount++;
}
if (loopCount == _checkItem.Count())
{
//Add new record with Qty and intial Qty
_stock.InitialQty += vm.Qty;
db.Stocks.Add(_stock);
db.SaveChanges();
}
}
}
}
//Generates Sales Invoice
public ActionResult SalesInvoice(int?id)
{
ASITPOSDBEntities db = new ASITPOSDBEntities();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var _sales = slsrepo.GetSales(id);
//check if id supplied is present or not.
if (_sales == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
else
{
var salitm = new List <SalesInvRpt>();
//foreach (var item in _sales.SalesItems)
//{
// var sal = new SalesInvRpt {
// ID = item.ID,
// Amount = item.Amount,
// Qty = item.Qty,
// Rate = item.Rate,
// SalesID = item.SalesID,
// StockID = item.StockID };
// salitm.Add(sal);
//}
salitm = (from sitem in _sales.SalesItems
join stocks in db.Stocks on sitem.StockID equals stocks.ID
join item in db.Items on stocks.ItemID equals item.ItemID into subtbl
from sub2 in subtbl.DefaultIfEmpty()
select new SalesInvRpt()
{
ID = sitem.ID, Amount = sitem.Amount, Qty = sitem.Qty, Rate = sitem.Rate, Proname = sub2.Name, SalesID = sitem.SalesID, StockID = sitem.StockID
}).ToList();
//var query = from person in people
// join pet in pets on person equals pet.Owner into gj
// from subpet in gj.DefaultIfEmpty()
// select new { person.FirstName, PetName = (subpet == null ? String.Empty : subpet.Name) };
LocalReport rpt = new LocalReport();
rpt = RptSetupClass.GetLocalReport("Sales.POSSalesInv01", salitm, null, null);
RptRDLCPDF(rpt);
return(View());
}
}
public ActionResult ProfitAndLoss(DateTime FrmDate, DateTime ToDate)
{
ASITPOSDBEntities db = new ASITPOSDBEntities();
List <ProfitAndLoss> prf = new List <ProfitAndLoss>();
var pro = db.Profitandloss(FrmDate, ToDate);
foreach (var item in pro)
{
prf.Add(item);
}
var exp = db.Expenses.Where(x => x.Date >= FrmDate && x.Date <= ToDate).ToList();
VmProfitLoss VMP = new VmProfitLoss();
VMP.Costofgood = prf[0].Costofgood;
VMP.grossprofit = prf[0].grossprofit;
VMP.totalsale = prf[0].totalsale;
VMP.expences = exp;
return(View(VMP));
}
/// <summary>
/// Displays Partial view for Stock expiry
/// </summary>
/// <returns></returns>
public PartialViewResult StockExpiry()
{
ASITPOSDBEntities db = new ASITPOSDBEntities();
// Repository<Stock> stockrep = new Repository<Stock>();
List<Stock> list = db.Stocks.SqlQuery("select * from Stock s where s.ExpiryDate - GETDATE() < 75").ToList();
return PartialView(list);
}
[AllowAnonymous]
[HttpPost]
public ActionResult Login(LoginViewModel lmodel, string returnUrl)
{
if (!ModelState.IsValid)
{
return View(lmodel);
}
ApplicationSignInManager signinManager = Request.GetOwinContext().Get<ApplicationSignInManager>();
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
SignInStatus SigninStatus = signinManager.PasswordSignIn(lmodel.Email.Trim(), lmodel.Password, lmodel.RememberMe, shouldLockout: false);
switch (SigninStatus)
{
case SignInStatus.Success:
return Redirect("Home/Index");
default:
ModelState.AddModelError("", "Invalid login attempt.");
return View(lmodel);
}
}
[Authorize]
public ActionResult Logout()
{
Request.GetOwinContext().Authentication.SignOut();
return Redirect("Login");
}
public ActionResult Product(string currentFilter,string searchString, int? page)
{
//ViewBag.CurrentSort = sortOrder;
//ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
//ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";
Repository<Item> rep = new Repository<Item>();
ASITPOSDBEntities db = new ASITPOSDBEntities();
var kkk = rep.GetAll();
var ttt = db.Items.ToList();
var lll = db.Catagories.ToList();
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
var param = _parm.GetProduct();
DataSet ds = _Data.GetDataSetResult(param);
var list = ds.Tables[0].DataTableToList<Product>();
if (!String.IsNullOrEmpty(searchString))
{
list = list.Where(s => s.ProductName.ToUpper().Contains(searchString.ToUpper())).ToList();
}
int pageSize = 5;
int pageNumber = (page ?? 1);
return View(list.ToPagedList(pageNumber, pageSize));
}
[HttpGet]
public ActionResult AddProduct()
{
var pap = _parm.GetCatagory();
DataSet ds = _Data.GetDataSetResult(pap);
var currencyList = ds.Tables[0].DataTableToList<BusinessEntity.Catagory>();
ViewBag.Catagory = currencyList.Select(x => new SelectListItem() { Value = x.catagoriid.ToString(), Text = x.catagoryname }).ToList();
return View();
}
[HttpPost]
public ActionResult AddProduct(Product pro)
{
var param = _parm.GetAddProduct(pro);
DataSet ds = _Data.GetDataSetResult(param);
return RedirectToAction("Product");
}
public ActionResult DeletProduct(string id)
{
var param = _parm.DeleteProduct(id);
DataSet ds = _Data.GetDataSetResult(param);
return RedirectToAction("Product");
}
public decimal TodaySales()
{
ASITPOSDBEntities db = new ASITPOSDBEntities();
var sales = db.Sales.Where(x => DbFunctions.DiffDays(x.Date, DateTime.Now) == 0).Sum(x => (decimal?)(x.GrandTotal)) ?? 0;
return sales;
}
/// <summary>
/// Calculates the Total Sales on Yesterday.
/// </summary>
/// <returns>returns total yesterday's sales</returns>
public decimal YesterdaySales()
{
ASITPOSDBEntities db = new ASITPOSDBEntities();
decimal sales = db.Sales.Where(x => DbFunctions.DiffDays(x.Date, DateTime.Now) == 1).Sum(x => (decimal?)(x.GrandTotal)) ?? 0;
return sales;
}
}
}
public PurchaseFilter()
{
db = new ASITPOSDBEntities();
}
