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