public ActionResult Index() { ClientModel m = new ClientModel(); m.lst_newsv = data.SqlQuery <News>("select * from News where IsShow = 1"); return(View(m)); }
public IActionResult GetTotal(DateTime?DT) { SalesTotalByDayView result = null; ReturnTotalByDayView resultReturn = null; if (DT == null) { DateTime date = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("Central Asia Standard Time")); result = data.SqlQuery <SalesTotalByDayView>("select * from SalesTotalByDayView where RegDt = @DT", new { DT = date.ToString("yyyy-MM-dd") }).FirstOrDefault(); resultReturn = data.SqlQuery <ReturnTotalByDayView>("select * from ReturnTotalByDayView where RegDt = @DT", new { DT = date.ToString("yyyy-MM-dd") }).FirstOrDefault(); } else { DateTime date = TimeZoneInfo.ConvertTime((DateTime)DT, TimeZoneInfo.FindSystemTimeZoneById("Central Asia Standard Time")); result = data.SqlQuery <SalesTotalByDayView>("select * from SalesTotalByDayView where RegDt = @DT", new { DT = date.ToString("yyyy-MM-dd") }).FirstOrDefault(); resultReturn = data.SqlQuery <ReturnTotalByDayView>("select * from ReturnTotalByDayView where RegDt = @DT", new { DT = date.ToString("yyyy-MM-dd") }).FirstOrDefault(); } if (result == null) { ViewBag.pribl = 0; ViewBag.totall = new SalesTotalByDayView() { RegDt = DT == null ? DateTime.Now : (DateTime)DT, IncomeCost = 0, SaleTotal = 0 }; } else { ViewBag.pribl = result.SaleTotal - result.IncomeCost; ViewBag.totall = result; } if (resultReturn == null) { ViewBag.rtotall = new ReturnTotalByDayView() { RegDt = DT == null ? DateTime.Now : (DateTime)DT, ReturnCost = 0 }; } else { ViewBag.rtotall = resultReturn; } ViewBag.PrixodobTG = data.GetAll <AvProfit>().FirstOrDefault().TotalIncomeTG; ViewBag.ProdajaobTG = data.GetAll <AvProfit>().FirstOrDefault().TotalSaleTG; ViewBag.OptovayaobTG = data.GetAll <AvProfit>().FirstOrDefault().TotalOptTG; ViewBag.Prixodob = data.GetAll <AvProfit>().FirstOrDefault().TotalIncome; ViewBag.Prodajaob = data.GetAll <AvProfit>().FirstOrDefault().TotalSale; ViewBag.Optovayaob = data.GetAll <AvProfit>().FirstOrDefault().TotalOpt; return(View("Index")); }
[HttpPost] // возвращаем товар public ActionResult Insert(HistorySaleView entity) { try { double sales = data.SqlQuery <double>("select SaleCost from ProductSales where Id = @id", new { id = entity.Id }).FirstOrDefault(); if (sales != 0) { if (entity.SaleCost > sales) { return(Ok("-1")); } } else { return(Ok("-1")); } int usrid = 0; if (User.FindFirstValue("UserId") != null) { usrid = Convert.ToInt32(User.FindFirstValue("UserId")); } int result = data.SqlExecuteProc("SP_AddProductReturn", new { Id = 0, Amount = entity.Amount, Comments = entity.Comments, ProductSaleId = entity.Id, UserId = usrid, RegDT = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("Central Asia Standard Time")) }); if (result > 0) { return(Ok("1")); } else { return(Ok("-1")); } } catch (Exception e) { return(Ok(e.Message)); } }
public ActionResult Get(string ProductCode, int PrId = 0) { if (ProductCode != null) { Products result; if (PrId > 0) { result = data.GetById <Products>(PrId); } else { result = data.SqlQuery <Products>("select * from Products WHERE [Code] = @Code;", new { Code = ProductCode }).FirstOrDefault(); } if (result != null) { result.costs = data.SqlQuery <AvCurrentCosts>("select * from AvCurrentCosts where ProductId = @prodId", new { prodId = result.Id }).FirstOrDefault(); if (result.costs == null || result.RemainCount <= 0) { return(Ok("Продукт не осталось!")); } string unt = data.GetById <Models.Units>((int)result.UnitId).Name; if (unt != null) { unt = result.RemainCount.ToString() + unt; } else { unt = result.RemainCount.ToString(); } return(Json(new { ProductId = result.Id, result.costs.OptCost, MySaleCost = result.costs.SaleCost, Amount = 1, result.costs.SaleCost, IsOptCost = false, RemainCount = unt, RemainFloat = result.RemainCount, Volume = result.Volume, VolumeTotal = result.Volume * 1, SaleCostTG = result.costs.SaleCost, ProductName = result.Name, OptCost2 = result.costs.OptCost })); } else { return(Ok("Такого продукта нет!")); } } return(Ok("Введите штрих код!")); }
public IActionResult ForDropDown([FromBody] DataManagerRequest dm) { IEnumerable <Products> DataSource = data.SqlQuery <Products>("select p.Id, p.Name + ' || ' + cast(p.RemainCount as varchar(30)) + u.Name as [Name] from Products as p inner join Units as u on p.UnitId = u.Id"); DataOperations operation = new DataOperations(); if (dm.Search != null && dm.Search.Count > 0) { DataSource = operation.PerformSearching(DataSource, dm.Search); //Search } if (dm.Sorted != null && dm.Sorted.Count > 0) //Sorting { DataSource = operation.PerformSorting(DataSource, dm.Sorted); } if (dm.Where != null && dm.Where.Count > 0) //Filtering { DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator); } int count = DataSource.Cast <Products>().Count(); return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource)); }
public IActionResult ForDropDown([FromBody] DataManagerRequest dm) { IEnumerable <Suppliers> DataSource = null;//= data.SqlQuery<Products>("select * from Products"); DataOperations operation = new DataOperations(); if (dm.Where != null && dm.Where.Count > 0) //Filtering { if (dm.Where.FirstOrDefault().value != null) { // DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator); DataSource = data.SqlQuery <Suppliers>($"SELECT [Id], [Name] from Suppliers where " + $"[Name] like CONCAT('%',@searching,'%') or " + $"[Code] like CONCAT('%',@searching,'%') ORDER BY Id OFFSET 0 ROWS FETCH NEXT 100 ROWS ONLY", new { searching = dm.Where.FirstOrDefault().value }); } } if (DataSource == null) { DataSource = data.SqlQuery <Suppliers>($"SELECT [Id], [Name] from Suppliers ORDER BY Id OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY"); } int count = data.SqlQuery <int>("select count(*) from Suppliers").FirstOrDefault(); return(dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource)); }
public ActionResult Get(string ProductCode, int PrId = 0) { if (ProductCode != null) { Products result; if (PrId > 0) { result = data.GetById <Products>(PrId); } else { result = data.SqlQuery <Products>("select * from Products WHERE [Code] = @Code;", new { Code = ProductCode }).FirstOrDefault(); } if (result != null) { return(Json(new { ProductId = result.Id, Amount = 1, Volume = result.Volume, ProductName = result.Name })); } else { return(Ok("Такого продукта нет!")); } } return(Ok("Введите штрих код!")); }
public async Task <IActionResult> Login(Users model) { if (model.LoginName == null || model.Password == null) { ModelState.AddModelError("", "Некорректные логин и(или) пароль"); return(View("Login", model)); } if (ModelState.IsValid) { Users user = data.SqlQuery <Users>("select * from [Users] where [LoginName] = @lname and [Password] = @pname", new { lname = model.LoginName, pname = model.Password }).FirstOrDefault(); if (user != null) { user.roles = data.GetById <Roles>((int)user.RoleId); await Authenticate(user); // аутентификация return(RedirectToAction("Index", "Home")); } ModelState.AddModelError("", "Некорректные логин и(или) пароль"); } return(View("Login", model)); }