private void ReportGridItem() { try { DataSet DsGrd = new DataSet(); StrCondition = string.Empty; int ReqId = Convert.ToInt32(ddlReqNo.SelectedValue.ToString()); DsGrd = obj_DMReqCancellation.GetRecordForItem("I", ReqId, out StrError); if (DsGrd.Tables.Count > 0 && DsGrd.Tables[0].Rows.Count > 0) { GridDtlsItem.DataSource = DsGrd.Tables[0]; GridDtlsItem.DataBind(); GridDtlsItem.Visible = true; } else { GridDtlsItem.DataSource = null; GridDtlsItem.DataBind(); } obj_DMReqCancellation = null; DsGrd = null; } catch (Exception ex) { throw new Exception(ex.Message); } }
private void SetInitialRow_GridItem() { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add("#", typeof(Int32)); dt.Columns.Add("ItemName", typeof(string)); dt.Columns.Add("ItemDesc", typeof(string)); dt.Columns.Add("RemarkForPO", typeof(string)); dt.Columns.Add("ItemCode", typeof(string)); dt.Columns.Add("MinStockLevel", typeof(string)); dt.Columns.Add("OrdQty", typeof(string)); dt.Columns.Add("AvlQty", typeof(string)); dt.Columns.Add("ItemId", typeof(string)); dt.Columns.Add("IsCancel", typeof(string)); dt.Columns.Add("Unit", typeof(string)); dr = dt.NewRow(); dr["#"] = 0; dr["ItemName"] = ""; dr["ItemCode"] = ""; dr["ItemDesc"] = ""; dr["RemarkForPO"] = ""; dr["MinStockLevel"] = ""; dr["OrdQty"] = ""; dr["AvlQty"] = ""; dr["ItemId"] = 0; dr["IsCancel"] = ""; dr["Unit"] = ""; dt.Rows.Add(dr); ViewState["CurrentTable2"] = dt; GridDtlsItem.DataSource = dt; GridDtlsItem.DataBind(); }
protected void ReportGrid_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName) { case ("Select"): { int CurrRow = Convert.ToInt32(e.CommandArgument); Label RequisitionCancelId = ((Label)ReportGrid.Rows[CurrRow].Cells[0].FindControl("LblEstimateId")); ViewState["ID"] = Convert.ToInt32(RequisitionCancelId.Text); int CancelType = ReportGrid.Rows[CurrRow].Cells[6].Text.Equals("False")?0:1; int RequisitionCafeId = Convert.ToInt32(ReportGrid.Rows[CurrRow].Cells[7].Text.ToString()); if (CancelType == 0) { Ds = obj_DMReqCancellation.GetRecordForEdit_ItemWise(Convert.ToInt32(RequisitionCancelId.Text), RequisitionCafeId, out StrError); } else { Ds = obj_DMReqCancellation.GetRecordForEdit_RequisitionWise(Convert.ToInt32(RequisitionCancelId.Text), RequisitionCafeId, out StrError); } if (Ds.Tables.Count > 0 && Ds.Tables[0].Rows.Count > 0) { lblEmployee.Text = Ds.Tables[0].Rows[0]["CancelledBy"].ToString(); TxtCancelDate.Text = Convert.ToDateTime(Ds.Tables[0].Rows[0]["CancelledDate"]).ToString("dd/MMM/yyyyy"); TxtCancelReason.Text = Ds.Tables[0].Rows[0]["Reason"].ToString(); RdoType.SelectedValue = Convert.ToBoolean(Ds.Tables[0].Rows[0]["CancelType"]).Equals(false) ? "I" : "R"; } else { MakeEmptyForm(); } if (Ds.Tables[1].Rows.Count > 0) { if (RdoType.SelectedValue == "I") { GridDtlsItem.DataSource = Ds.Tables[1]; GridDtlsItem.DataBind(); ViewState["CurrentTable1"] = Ds.Tables[1]; T2.Visible = true; T1.Visible = false; GridDetails.Visible = false; GridDtlsItem.Visible = true; FillCombo(); ddlReqNo.SelectedValue = Ds.Tables[0].Rows[0]["RequisitionCafeId"].ToString(); lblCafeteria.Text = Ds.Tables[1].Rows[0]["Cafeteria"].ToString(); } else { GridDetails.DataSource = Ds.Tables[1]; GridDetails.DataBind(); ViewState["CurrentTable1"] = Ds.Tables[1]; T1.Visible = true; T2.Visible = false; GridDetails.Visible = true; GridDtlsItem.Visible = false; } } Ds = null; // Obj_StockMaster = null; BtnUpdate.Visible = true; BtnSave.Visible = false; MakeReadOnlyForm(false); break; } case ("Delete"): { int CurrRow = Convert.ToInt32(e.CommandArgument); Label RequisitionCancelId = ((Label)ReportGrid.Rows[CurrRow].Cells[0].FindControl("LblEstimateId")); ViewState["ID"] = Convert.ToInt32(RequisitionCancelId.Text); string DeleteCancelType = ReportGrid.Rows[CurrRow].Cells[6].Text.Equals("False") ? "I" : "R"; int RequisitionCafeId = Convert.ToInt32(ReportGrid.Rows[CurrRow].Cells[7].Text.ToString()); int DeleteDetails = obj_DMReqCancellation.DeleteRequisitionCancel(DeleteCancelType, Convert.ToInt32(RequisitionCancelId.Text), RequisitionCafeId, out StrError); if (DeleteDetails > 0) { obj_Comman.ShowPopUpMsg("Record Deleted Successfully", this.Page); MakeEmptyForm(); } } break; } } catch (Exception ex) { throw new Exception(ex.Message); } }