private void ReportGrid(string FromDate, string ToDate, string StrCondition)
{
try
{
DsDeviationGrd = Obj_Deviation.ShowStockInHand(FromDate, ToDate, StrCondition, out StrError);
if (DsDeviationGrd.Tables.Count > 0 && DsDeviationGrd.Tables[0].Rows.Count > 0)
{
DeviationGrid.DataSource = DsDeviationGrd.Tables[0];
DeviationGrid.DataBind();
DeviationGrid.Columns[13].Visible = false;
DeviationGrid.Columns[14].Visible = false;
//GetAmount();
((TextBox)DeviationGrid.Rows[0].FindControl("GrtxtPhyClosing")).Focus();
}
else
{
DeviationGrid.DataSource = null;
DeviationGrid.DataBind();
SetInitialRow();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void SetInitialRow()
{
try
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("#", typeof(Int32)));
dt.Columns.Add(new DataColumn("Category", typeof(string)));
dt.Columns.Add(new DataColumn("Code", typeof(string)));
dt.Columns.Add(new DataColumn("Product", typeof(string)));
dt.Columns.Add(new DataColumn("UnitID", typeof(Int32)));
dt.Columns.Add(new DataColumn("Unit", typeof(string)));
dt.Columns.Add(new DataColumn("MRP", typeof(decimal)));
dt.Columns.Add(new DataColumn("LocationID", typeof(Int32)));
dt.Columns.Add(new DataColumn("Location", typeof(string)));
dt.Columns.Add(new DataColumn("Closing", typeof(decimal)));
dt.Columns.Add(new DataColumn("SystemAmount", typeof(decimal)));
dt.Columns.Add(new DataColumn("PhyClosing", typeof(decimal)));
dt.Columns.Add(new DataColumn("Deviation", typeof(decimal)));
dt.Columns.Add(new DataColumn("DeviationAmount", typeof(decimal)));
dt.Columns.Add(new DataColumn("PhyAmount", typeof(decimal)));
dt.Columns.Add(new DataColumn("PhyDeviationQty", typeof(decimal)));
dt.Columns.Add(new DataColumn("PhyDeviationAmt", typeof(decimal)));
dt.Columns.Add(new DataColumn("PhyDeviationAmount", typeof(decimal)));
dr = dt.NewRow();
dr["#"] = 0;
dr["Category"] = "";
dr["Code"] = "";
dr["Product"] = "";
dr["UnitID"] = 0;
dr["Unit"] = "";
dr["MRP"] = 0;
dr["LocationID"] = 0;
dr["Location"] = "";
dr["Closing"] = 0;
dr["SystemAmount"] = 0;
dr["PhyClosing"] = 0;
dr["Deviation"] = 0;
dr["DeviationAmount"] = 0;
dr["PhyAmount"] = 0;
dr["PhyDeviationQty"] = 0;
dr["PhyDeviationAmt"] = 0;
dr["PhyDeviationAmount"] = 0;
dt.Rows.Add(dr);
ViewState["CurrentTable"] = dt;
DeviationGrid.DataSource = dt;
DeviationGrid.DataBind();
dt = null;
dr = null;
DeviationGrid.Columns[13].Visible = false;
DeviationGrid.Columns[14].Visible = false;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void ReportGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
switch (e.CommandName)
{
case ("Select"):
{
if (Convert.ToInt32(e.CommandArgument) != 0)
{
ViewState["ID"] = Convert.ToInt32(e.CommandArgument);
Ds = Obj_Deviation.GetRecordForEdit(Convert.ToInt32(e.CommandArgument), out StrError);
if (Ds.Tables[0].Rows.Count > 0)
{
DeviationGrid.DataSource = Ds.Tables[0];
DeviationGrid.DataBind();
ViewState["CurrentTable"] = Ds.Tables[0];
BtnUpdate.Visible = true;
BtnSave.Visible = false;
BtnShow.Visible = false;
lblDevationPeriod.Text = "Deviation Period - " + Ds.Tables[0].Rows[0]["DevationPeriod"].ToString();
MakeControlDisable(1);
DeviationGrid.Columns[13].Visible = false;
DeviationGrid.Columns[14].Visible = false;
(TxtSysamount.Text) = Ds.Tables[0].Rows[0]["SysAmt"].ToString();
(TxtPhyamount.Text) = Ds.Tables[0].Rows[0]["PhyAmt"].ToString();
(TxtTotDeviationAmount.Text) = (Convert.ToDecimal((TxtSysamount.Text)) - Convert.ToDecimal((TxtPhyamount.Text))).ToString("#0.00");
// GetAmount();
ScriptManager.RegisterStartupScript(this, GetType(), "TotalForUpdates", "javascript:TotalForUpdates();", true);
}
else
{
MakeEmptyForm();
}
Ds = null;
Obj_Deviation = null;
}
break;
}
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}