public ProductStockModel UpdateProductStock(ProductStockModel _productStockModel)
        {
            try
            {
                using (_context = new HSSNInventoryEntities())
                {
                    var data =
                        _context.ProductStocks.FirstOrDefault(a => a.ProductId == _productStockModel.ProductId &&
                                                                   a.OrganisationId == _productStockModel.OrganisationId &&
                                                                   a.WareHouseId == _productStockModel.WareHouseId);
                    if (_productStockModel.InOutMode == "IN")
                    {
                        if (data != null) data.CurrentStock += _productStockModel.CurrentStock;
                    }
                    else
                    {
                        if (data != null) data.CurrentStock -= _productStockModel.CurrentStock;
                    }
                    _context.Entry(data).State = EntityState.Modified;
                    _context.SaveChanges();
                    return _productStockModel;
                }
            }
            catch (Exception e)
            {

                Console.WriteLine(e);
                throw;
            }
        }
        private List<ProductStockModel> datafunc()
        {
            var listdata = new List<ProductStockModel>();
            foreach (var row in grdOpeningstock.Rows)
            {
                var tempdata = new ProductStockModel()
                {
                    ProductId = Convert.ToInt32(row.Cells["ProductId"].Value),
                    OrganisationId = 1,
                    WareHouseId = Convert.ToInt32(cmbWarehouse.SelectedValue),
                    OpeningStock = Convert.ToInt32(row.Cells["OpeningStock"].Value),
                    CurrentStock = Convert.ToInt32(row.Cells["OpeningStock"].Value),
                    InOutMode = "IN",

                };
                listdata.Add(tempdata);

            }
            _commonservice.SaveProductStock(listdata);

            return listdata;
        }