public ActionResult CkEditorNews(int id) { AdminNewModel n = new AdminNewModel(); if (id != 0) { n.news = data.GetById <News>(id); } return(View(n)); }
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 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)); }