protected void Page_Load(object sender, EventArgs e) { if (Session["id"] != null) { if (Session["id"].Equals("Admin")) { stockingrepo = new StockingDetailsRepository(db); itemRepo = new ItemRepository(db); if (!IsPostBack) { BindData(); //gvItemDetails.DataSource = itemRepo.GetAll().ToList(); //gvItemDetails.DataBind(); //ddlbrandid.DataSource = itemRepo.GetAll().ToList(); //ddlbrandid.DataSource=Product;; //ddlbrandid.DataTextField = "BrandName"; //ddlbrandid.DataValueField = "BrandId"; // ddlbrandid.DataBind(); } } else { lblMsg.Text = "you don't have permission for this page"; } } else { Response.Redirect("~/Login/Login.aspx"); } }
protected void gvItemDetails_RowDataBound(object sender, GridViewRowEventArgs e) { DropDownList ddlProduct = (DropDownList)e.Row.FindControl("ddlEditProduct"); if (ddlProduct != null) { Prorepo = new ProductRepository(db); ddlProduct.DataSource = Prorepo.GetAll().Where(v => v.TenantId == tenantId).ToList(); ddlProduct.DataTextField = "ProductName"; ddlProduct.DataValueField = "ProductId"; ddlProduct.DataBind(); ddlProduct.SelectedValue = gvItemDetails.DataKeys[e.Row.RowIndex].Values[1].ToString(); Label lblPro = (Label)e.Row.FindControl("lblProductId"); if (lblPro != null) { lblPro.Text = "3"; } } DropDownList ddlvendor = (DropDownList)e.Row.FindControl("ddlEditvendor"); if (ddlvendor != null) { stockingrepo = new StockingDetailsRepository(db); vendorRepo = new vendorRepository(db); ddlvendor.DataSource = vendorRepo.GetAll().Where(v => v.TenantId == tenantId).ToList(); ddlvendor.DataTextField = "VendorName"; ddlvendor.DataValueField = "VendorID"; ddlvendor.DataBind(); ddlvendor.SelectedValue = gvItemDetails.DataKeys[e.Row.RowIndex].Values[2].ToString(); Label lblvend = (Label)e.Row.FindControl("lblvendorid"); if (lblvend != null) { lblvend.Text = "3"; } } }
private List <StockingItemsReport_Result> GetData6(DateTime startDate, DateTime endDate, int tenantId) { stockingrepo = new StockingDetailsRepository(db); return(stockingrepo.GetProductStockingItem(startDate, endDate, tenantId)); }
private List <PeriodicReport_Result> GetData4(DateTime startDate, DateTime endDate, int id, int tenantId) { stockingrepo = new StockingDetailsRepository(db); return(stockingrepo.GetProductStock(id, startDate, endDate, tenantId)); }