public void ReportGrid(string RepCondition) { try { DataSet DsGrd = new DataSet(); DsGrd = Obj_MaterialInwardReg.GetInwardDetailsReport(RepCondition, out StrError); if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0) { if (!FlagPrint) { ImgBtnPrint.Visible = true; } if (!FlagPrint) { ImgBtnExport.Visible = true; } GridInwordDetails.DataSource = DsGrd.Tables[0]; GridInwordDetails.DataBind(); lblCount.Text = DsGrd.Tables[0].Rows.Count + " Record Found"; lblCount.Visible = true; } else { GridInwordDetails.DataSource = null; GridInwordDetails.DataBind(); lblCount.Text = DsGrd.Tables[0].Rows.Count + " Record Found"; lblCount.Visible = true; SetInitialRow(); } //Obj_Quot = null; DsGrd = null; } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void GridInword_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName) { case ("Select"): { DataSet DSInwardDetails = new DataSet(); DSInwardDetails = Obj_MaterialInwardReg.GetInwordDetailsReport(Convert.ToString(GridInword.Rows[Convert.ToInt32(e.CommandArgument)].Cells[2].Text.Trim()), out StrError); if (DSInwardDetails.Tables.Count > 0 && DSInwardDetails.Tables[0].Rows.Count > 0) { GridInwordDetails.Visible = true; GRIDDETAILS.Visible = true; GridInwordDetails.DataSource = DSInwardDetails.Tables[0]; GridInwordDetails.DataBind(); } else { GridInwordDetails.Visible = false; GRIDDETAILS.Visible = false; GridInwordDetails.DataSource = null; GridInwordDetails.DataBind(); } } break; } } catch (Exception ex) { } }
//========Important Required for Excel Export Must============= protected void GridInwordDetails_PageIndexChanging(object sender, GridViewPageEventArgs e) { try { this.GridInwordDetails.PageIndex = e.NewPageIndex; DataSet DsGrd = new DataSet(); StrCondition = string.Empty; if (ChkFrmDate.Checked == true) { StrCondition = StrCondition + " and IR.InwardDate between '" + Convert.ToDateTime(txtFromDate.Text).ToString("MM-dd-yyyy") + "' AND '" + Convert.ToDateTime(txtToDate.Text).ToString("MM-dd-yyyy") + "' "; } else { StrCondition = StrCondition + " AND IR.InwardDate between '01-01-1975' AND '" + DateTime.Now.ToString("MM-dd-yyyy") + "' "; } if (Convert.ToInt32(ddlSupp.SelectedValue) > 0) { StrCondition = StrCondition + " and SM.SuplierId =" + Convert.ToInt32(ddlSupp.SelectedValue); } if (Convert.ToInt32(ddlInwardNo.SelectedValue) > 0) { StrCondition = StrCondition + " and IR.InwardId=" + Convert.ToInt32(ddlInwardNo.SelectedValue); } if (!string.IsNullOrEmpty(ddlItemName.Text) && Convert.ToInt32(ddlItemName.SelectedValue) > 0) { StrCondition = StrCondition + " and IM.ItemId=" + Convert.ToInt32(ddlItemName.SelectedValue); } if (!string.IsNullOrEmpty(ddlCategory.Text) && Convert.ToInt32(ddlCategory.SelectedValue) > 0) { StrCondition = StrCondition + " And IC.CategoryId=" + Convert.ToInt32(ddlCategory.SelectedValue); } // //if (!Convert.ToBoolean(Session["IsCentral"].ToString())) // //{ // StrCondition = StrCondition + " AND IR.Location=" + Convert.ToInt32(Session["CafeteriaId"].ToString()); //// } DsGrd = Obj_MaterialInwardReg.GetInwardDetailsReport(StrCondition, out StrError); if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0) { GridInwordDetails.DataSource = DsGrd.Tables[0]; GridInwordDetails.DataBind(); lblCount.Text = DsGrd.Tables[0].Rows.Count + " Record Found"; lblCount.Visible = true; } else { GridInwordDetails.DataSource = null; GridInwordDetails.DataBind(); lblCount.Text = DsGrd.Tables[0].Rows.Count + " Record Found"; lblCount.Visible = true; SetInitialRow(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public void SetInitialRow() { try { DataTable dt = new DataTable(); DataRow dr = null; //dt.Columns.Add(new DataColumn("#", typeof(int))); dt.Columns.Add(new DataColumn("InwardNo", typeof(string))); dt.Columns.Add(new DataColumn("InwardDate", typeof(string))); dt.Columns.Add(new DataColumn("PONO", typeof(string))); dt.Columns.Add(new DataColumn("type", typeof(string))); dt.Columns.Add(new DataColumn("SuplierName", typeof(string))); dt.Columns.Add(new DataColumn("ItemName", typeof(string))); dt.Columns.Add(new DataColumn("Unit", typeof(string))); dt.Columns.Add(new DataColumn("InwardQty", typeof(decimal))); dt.Columns.Add(new DataColumn("OrderQty", typeof(decimal))); dt.Columns.Add(new DataColumn("PendingQty", typeof(decimal))); dt.Columns.Add(new DataColumn("InwardRate", typeof(decimal))); dt.Columns.Add(new DataColumn("PORate", typeof(decimal))); dt.Columns.Add(new DataColumn("Diffrence", typeof(decimal))); dt.Columns.Add(new DataColumn("Amount", typeof(decimal))); dt.Columns.Add(new DataColumn("TaxPer", typeof(decimal))); dt.Columns.Add(new DataColumn("DiscPer", typeof(decimal))); dt.Columns.Add(new DataColumn("DiscAmt", typeof(decimal))); dt.Columns.Add(new DataColumn("TaxAmount", typeof(decimal))); dt.Columns.Add(new DataColumn("NetAmount", typeof(decimal))); dr = dt.NewRow(); //dr["#"] = 0; dr["InwardNo"] = ""; dr["InwardDate"] = ""; dr["PONO"] = ""; dr["type"] = ""; dr["Unit"] = ""; dr["SuplierName"] = ""; dr["ItemName"] = ""; dr["InwardQty"] = 0; dr["OrderQty"] = 0; dr["InwardRate"] = 0; dr["PORate"] = 0; dr["Diffrence"] = 0; dr["Amount"] = 0; dr["TaxPer"] = 0; dr["TaxAmount"] = 0; dr["DiscPer"] = 0; dr["DiscAmt"] = 0; dr["NetAmount"] = 0; dt.Rows.Add(dr); ViewState["CurrentTable"] = dt; GridInwordDetails.DataSource = dt; GridInwordDetails.DataBind(); dt = null; dr = null; } catch (Exception ex) { throw; } }
protected void ImgBtnExport_Click(object sender, ImageClickEventArgs e) { try { DataSet DsGrd = new DataSet(); StrCondition = string.Empty; if (ChkFrmDate.Checked == true) { StrCondition = StrCondition + " and IR.InwardDate between '" + Convert.ToDateTime(txtFromDate.Text).ToString("MM-dd-yyyy") + "' AND '" + Convert.ToDateTime(txtToDate.Text).ToString("MM-dd-yyyy") + "' "; } else { StrCondition = StrCondition + " AND IR.InwardDate between '01-01-1975' AND '" + DateTime.Now.ToString("MM-dd-yyyy") + "' "; } if (!string.IsNullOrEmpty(ddlItemName.Text) && Convert.ToInt32(ddlItemName.SelectedValue) > 0) { StrCondition = StrCondition + " and IM.ItemId=" + Convert.ToInt32(ddlItemName.SelectedValue); } if (!Convert.ToBoolean(Session["IsCentral"].ToString())) { StrCondition = StrCondition + " AND IR.Location =" + Convert.ToInt32(Session["CafeteriaId"].ToString()); } if (!string.IsNullOrEmpty(ddlSubCategory.Text) && Convert.ToInt32(ddlSubCategory.SelectedValue) > 0) { StrCondition = StrCondition + " And IM.SubCategoryId=" + Convert.ToInt32(ddlSubCategory.SelectedValue); } DsGrd = Obj_ArticleHistory.GetInwardDetailsReport(StrCondition, out StrError); if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0) { //========Call Register GridView GridExp = new GridView(); GridExp.DataSource = DsGrd.Tables[0]; GridExp.DataBind(); obj_Comman.Export("ArticlesHistory.xls", GridExp); } else { obj_Comman.ShowPopUpMsg("No Data Found To Export..!", this.Page); DsGrd.Dispose(); GridInwordDetails.DataSource = null; GridInwordDetails.DataBind(); } //ds = null; } catch (ThreadAbortException tex) { } catch (Exception ex) { throw new Exception(ex.Message); } }
public void SetInitialRow() { try { DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("InwardDate", typeof(string))); dt.Columns.Add(new DataColumn("Category", typeof(string))); dt.Columns.Add(new DataColumn("ItemName", typeof(string))); dt.Columns.Add(new DataColumn("ItemDesc", typeof(string))); dt.Columns.Add(new DataColumn("Unit", typeof(string))); dt.Columns.Add(new DataColumn("InwardQty", typeof(decimal))); dt.Columns.Add(new DataColumn("InwardRate", typeof(decimal))); dt.Columns.Add(new DataColumn("Amount", typeof(decimal))); dr = dt.NewRow(); dr["InwardDate"] = ""; dr["Category"] = ""; dr["ItemName"] = ""; dr["ItemDesc"] = ""; dr["Unit"] = ""; dr["InwardQty"] = 0; dr["InwardRate"] = 0; dr["Amount"] = 0; dt.Rows.Add(dr); ViewState["CurrentTable"] = dt; GridInwordDetails.DataSource = dt; GridInwordDetails.DataBind(); dt = null; dr = null; } catch (Exception ex) { throw; } }