protected void Page_Load(object sender, EventArgs e)
{
ICEBranchViewDiv.Style["height"] = sHeight;
ICEDB db = new ICEDB();
DataTable dt;
if (sECEType == 11)
{
dt = db.GetBranchStatusRV();
}
else
{
dt = db.GetBranchStatusHV();
}
//DataTable dt = db.GetBranchStatus(sECEType);
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
string HRV;
if (sECEType > 11)
{
HRV = "HV";
BranchGrid.RowStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#dee9fc");
}
else
{
HRV = "RV";
BranchGrid.RowStyle.BackColor = System.Drawing.Color.LightYellow;
}
LblTotal.Text = "ICE -" + HRV;
try
{
Flora.Text = dt.Compute("SUM(C0)", "").ToString();
HUB.Text = dt.Compute("SUM(C1)", "").ToString();
Maker.Text = dt.Compute("SUM(C2)", "").ToString();
Checker.Text = dt.Compute("SUM(C3)", "").ToString();
Approved.Text = dt.Compute("SUM(C4)", "").ToString();
Admin.InnerText = dt.Compute("SUM(C5)", "").ToString();
Admin.HRef = "../CreateORE.aspx?ECEType=" + sECEType;
if ((Admin.InnerText != "0") && (Admin.InnerText != ""))
{
Admin.Style["background-color"] = "Yellow";
Admin.Style["color"] = "Red";
}
ORE.Text = dt.Compute("SUM(C6)", "").ToString();
Total.Text = dt.Compute("SUM(T)", "").ToString();
}
catch
{
}
dt.Dispose();
BranchGrid.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
RunDB db = new RunDB();
DataTable dt = db.GetRunCount();
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
dt.Dispose();
BranchGrid.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
OCEBranchViewDiv.Style["height"] = sHeight;
OCEDB db = new OCEDB();
DataTable dt;
if (sClearingType == 1)
{
dt = db.GetBranchStatusRV();
}
else
{
dt = db.GetBranchStatusHV();
}
//DataTable dt = db.GetBranchStatus(sClearingType);
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
string HRV;
if (sClearingType > 1)
{
HRV = "HV";
BranchGrid.RowStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#dee9fc");
}
else
{
HRV = "RV";
BranchGrid.RowStyle.BackColor = System.Drawing.Color.LightYellow;
}
LblTotal.Text = "OCE -" + HRV;
try
{
Scanman.Text = dt.Compute("SUM(S1)", "").ToString();
Maker.Text = dt.Compute("SUM(S2)", "").ToString();
Checker.Text = dt.Compute("SUM(S4)", "").ToString();
Admin.InnerText = dt.Compute("SUM(S5)", "").ToString();
Admin.HRef = "../CreateOCE.aspx?ClearingType=" + sClearingType;
if ((Admin.InnerText != "0") && (Admin.InnerText != ""))
{
Admin.Style["background-color"] = "Yellow";
Admin.Style["color"] = "Red";
}
PBM.Text = dt.Compute("SUM(S6)", "").ToString();
Total.Text = dt.Compute("SUM(T)", "").ToString();
IQA.Text = dt.Compute("SUM(S8)", "").ToString();
IRE.Text = dt.Compute("SUM(S9)", "").ToString();
}
catch
{
}
dt.Dispose();
BranchGrid.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
ICEBranchViewDiv.Style["height"] = sHeight;
ICEDB db = new ICEDB();
DataTable dt;
if (sECEType == 11)
{
dt = db.GetBranchRejectedStatusRV();
}
else
{
dt = db.GetBranchRejectedStatusHV();
}
//DataTable dt = db.GetBranchStatus(sECEType);
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
string HRV;
if (sECEType > 11)
{
HRV = "HV";
BranchGrid.RowStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#dee9fc");
}
else
{
HRV = "RV";
BranchGrid.RowStyle.BackColor = System.Drawing.Color.LightYellow;
}
LblTotal.Text = "ICE Rej -" + HRV;
try
{
Maker.Text = dt.Compute("SUM(C0)", "").ToString();
Checker.Text = dt.Compute("SUM(C1)", "").ToString();
}
catch
{
}
dt.Dispose();
BranchGrid.Dispose();
}
protected void Page_PreRender(object sender, EventArgs e)
{
ICEDB db = new ICEDB();
DataTable dt = db.GetZoneStatus(Int32.Parse(Request.Cookies["ZoneID"].Value), Int32.Parse(Session["CurrentClearingType"].ToString()));
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
try
{
BranchGrid.FooterRow.Cells[1].Text = dt.Compute("SUM(Maker)", "").ToString();
BranchGrid.FooterRow.Cells[2].Text = dt.Compute("SUM(Checker)", "").ToString();
}
catch
{
}
dt.Dispose();
BranchGrid.Dispose();
}
protected void Page_PreRender(object sender, EventArgs e)
{
DropDownList ECEList = (DropDownList)Page.FindControl("ClearingTypeList");
DropDownList BrList = (DropDownList)Page.FindControl("BranchList");
ICEDB db = new ICEDB();
DataTable dt = db.GetCheckQueue(Int32.Parse(BrList.SelectedValue), Int32.Parse(ECEList.SelectedValue));
BranchGrid.DataSource = dt;
BranchGrid.DataBind();
try
{
BranchGrid.FooterRow.Cells[1].Text = dt.Compute("SUM(CheckCount)", "").ToString();
BranchGrid.FooterRow.Cells[2].Text = dt.Compute("SUM(TotalAmount)", "").ToString();
}
catch
{
}
dt.Dispose();
BranchGrid.Dispose();
}