public void loadData() { try { DataSet getDsVal = new DataSet(); ProductDetail obj = new ProductDetail(); obj.ProductDetailID = Convert.ToInt32(Request.QueryString["detaiiId"]); getDsVal = ProductDetailBLL.GetProductDetailByDetailID(obj); if (getDsVal != null) { txtQuantityUnit.Text = getDsVal.Tables[0].Rows[0]["QuantityUnit"].ToString(); txtDiscount.Text = getDsVal.Tables[0].Rows[0]["Discount"].ToString(); txtSalePrice.Text = getDsVal.Tables[0].Rows[0]["SalePrice"].ToString(); txtDateExpired.Text = getDsVal.Tables[0].Rows[0]["DateExpired"].ToString(); drpProductMaster.SelectedValue = getDsVal.Tables[0].Rows[0]["ProductID"].ToString(); txtCostPrice.Text = getDsVal.Tables[0].Rows[0]["CostPrice"].ToString(); txtStatus.Text = getDsVal.Tables[0].Rows[0]["Status"].ToString(); DateCreated = Convert.ToDateTime(getDsVal.Tables[0].Rows[0]["DateCreated"].ToString()).Date; DateUpdated = Convert.ToDateTime(getDsVal.Tables[0].Rows[0]["DateUpdated"].ToString()).Date; DateExpired = Convert.ToDateTime(getDsVal.Tables[0].Rows[0]["DateExpired"].ToString()).Date; } } catch (Exception) { throw; } }
protected void gdvlistProductDetail_Sorting(object sender, GridViewSortEventArgs e) { DataView sortedView; string sortingDirection = string.Empty; if (direction == SortDirection.Ascending) { direction = SortDirection.Descending; sortingDirection = "Desc"; } else { direction = SortDirection.Ascending; sortingDirection = "Asc"; } ProductDetail obj = new ProductDetail(); obj.ProductMasterID = Convert.ToInt32(Request.QueryString["ProMasid"]); ds = ProductDetailBLL.GetProductDetailByID(obj); sortedView = new DataView(ds.Tables[0]); sortedView.Sort = e.SortExpression + " " + sortingDirection; Session["SortedView"] = sortedView; gdvlistProductDetail.DataSource = sortedView; gdvlistProductDetail.DataBind(); }
protected void gdvDetails_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName.Equals("UpdateDep")) { Label ID = (Label)gdvDetails.Rows[gdvDetails.EditIndex].FindControl("lblProd_Id"); TextBox SP = (TextBox)gdvDetails.Rows[gdvDetails.EditIndex].Cells[0].FindControl("txtSP"); TextBox Exp = (TextBox)gdvDetails.Rows[gdvDetails.EditIndex].FindControl("txtEXP"); TextBox CP = (TextBox)gdvDetails.Rows[gdvDetails.EditIndex].FindControl("txtCP"); ProductDetail objdrp = new ProductDetail(); objdrp.ProductDetailID = int.Parse(ID.Text); DateTime resDate; if (DateTime.TryParse(Exp.Text, out resDate)) { objdrp.DateExpired = resDate; } else { WebMessageBoxUtil.Show("Invalid input in Expiry Date field "); gdvDetails.EditIndex = -1; //BindGrid(); return; } float res; if (float.TryParse(SP.Text, out res)) { objdrp.SalePrice = res; float res2; if (float.TryParse(CP.Text, out res2)) { objdrp.CostPrice = res2; objdrp.DateUpdated = DateTime.Now; ProductDetailBLL sdBLL = new ProductDetailBLL(); sdBLL.Update(objdrp); } else { WebMessageBoxUtil.Show("Invalid input in Cost Price field "); } } else { WebMessageBoxUtil.Show("Invalid input in Sale Price field "); } } } catch (Exception exp) { } finally { gdvDetails.EditIndex = -1; BindGrid(); } }
public void BindgdvlistProductDetail() { if (Request.QueryString["ProMasid"] != null) { ProductDetail obj = new ProductDetail(); obj.ProductMasterID = Convert.ToInt32(Request.QueryString["ProMasid"]); ds = ProductDetailBLL.GetProductDetailByID(obj); gdvlistProductDetail.DataSource = ds; gdvlistProductDetail.DataBind(); } }
public void BindGrid() { DataSet ds = new DataSet(); ProductDetail objdrp = new ProductDetail(); currentId = int.Parse(Session["prod_ID"].ToString()); objdrp.ProductMasterID = currentId; ds = ProductDetailBLL.GetProductDetailByID(objdrp); gdvDetails.DataSource = ds; gdvDetails.DataBind(); }
protected void gdvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { Label ID = (Label)gdvDetails.Rows[e.RowIndex].FindControl("lblProd_Id"); ProductDetail objdrp = new ProductDetail(); objdrp.ProductDetailID = int.Parse(ID.Text); ProductDetailBLL sdBLL = new ProductDetailBLL(); sdBLL.Delete(objdrp); } catch (Exception exp) { } finally { gdvDetails.EditIndex = -1; BindGrid(); } }
protected void drpOrderDetail_SelectedIndexChanged(object sender, EventArgs e) { DropDownList dpList = (DropDownList)sender; ProductDetail pd = new ProductDetail(); pd.ProductMasterID = int.Parse(dpList.SelectedValue); DataSet ds_temp = ProductDetailBLL.GetProductDetailByID(pd); // ds_temp.Tables[0].Columns //Label lbl = gdvOrderDetail.Rows[gdvOrderDetail.SelectedIndex].FindControl("lblCP") as Label; //lbl.Text = "1.0"; //Label lbl_SP = gdvOrderDetail.Rows[gdvOrderDetail.SelectedIndex].FindControl("lblSP") as Label; //lbl_SP.Text = "1.2"; Label lbl = gdvOrderDetail.Rows[gdvOrderDetail.EditIndex].FindControl("lblSP") as Label; lbl.Text = "3.2"; Label lbl1 = gdvOrderDetail.Rows[gdvOrderDetail.EditIndex].FindControl("lblCP") as Label; lbl1.Text = "2.2"; }