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); }
}
