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));
}
