void showStatus()
{
if (!Page.IsPostBack)
{
InsertRequestDAO requestDAO = new InsertRequestDAO();
StatusGrid.DataSource = requestDAO.ShowRequestList(Session["Requester"].ToString());
StatusGrid.DataBind();
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
ICEDB db = new ICEDB();
DataTable dt = db.GetCheckStatus(Int32.Parse(RoutingNo), Int32.Parse(ClearingType));
StatusGrid.DataSource = dt;
StatusGrid.DataBind();
try
{
StatusGrid.FooterRow.Cells[1].Text = dt.Compute("SUM(CheckCount)", "").ToString();
StatusGrid.FooterRow.Cells[2].Text = dt.Compute("SUM(TotalAmount)", "").ToString();
}
catch
{
}
dt.Dispose();
StatusGrid.Dispose();
}
protected void StatusGrid_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{
if (e.CommandName.StartsWith("Move"))
{
Store store = AbleContext.Current.Store;
store.OrderStatuses.Sort("OrderBy");
int orderStatusId = AlwaysConvert.ToInt(e.CommandArgument.ToString());
int index;
switch (e.CommandName)
{
case "MoveUp":
index = store.OrderStatuses.IndexOf(orderStatusId);
if (index > 0)
{
OrderStatus tempStatus = store.OrderStatuses[index - 1];
store.OrderStatuses[index - 1] = store.OrderStatuses[index];
store.OrderStatuses[index] = tempStatus;
}
break;
case "MoveDown":
index = store.OrderStatuses.IndexOf(orderStatusId);
if (index < store.OrderStatuses.Count - 1)
{
OrderStatus tempStatus = store.OrderStatuses[index + 1];
store.OrderStatuses[index + 1] = store.OrderStatuses[index];
store.OrderStatuses[index] = tempStatus;
}
break;
}
// make sure order statuses are in order
index = 0;
foreach (OrderStatus status in store.OrderStatuses)
{
status.OrderBy = (short)index;
index++;
}
store.Save();
// rebind grid to reflect update
StatusGrid.DataBind();
}
}
protected void LoadGridChart2()
{
SqlCommand cmd = new SqlCommand("SP_GetGridData_Charts", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IMODE", SqlDbType.Int).Value = 1;
DataSet dsGrid = new DataSet();
StatusGrid.DataBind();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dsGrid);
if (dsGrid != null && dsGrid.Tables.Count > 0 && dsGrid.Tables[0].Rows.Count > 0)
{
StatusGrid.DataSource = dsGrid.Tables[0];
StatusGrid.DataBind();
}
else
{
StatusGrid.DataSource = new String[] { };
StatusGrid.DataBind();
}
}