private void LoadData()
{
try
{
hdnPageNumber.Value = "1";
royaltorActivityBL = new RoyaltorActivityBL();
/* WOS-389 - changes - modified by Harish
* DataSet activityData = royaltorActivityBL.GetActivityData(out nextRunTime, out errorId);*/
DataSet activityData = royaltorActivityBL.GetActivityData(out errorId);
royaltorActivityBL = null;
if (activityData.Tables.Count != 0 && errorId != 2)
{
Session["RoyActivityData"] = activityData.Tables[0];
Utilities.PopulateGridPage(1, activityData.Tables[0], gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else if (activityData.Tables.Count == 0 && errorId != 2)
{
Utilities.PopulateGridPage(1, activityData.Tables[0], gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);;
}
else
{
util = new Utilities();
util.GenericExceptionHandler("Error in loading the grid data.");
util = null;
}
}
catch (Exception ex)
{
util = new Utilities();
util.GenericExceptionHandler("Error in loading Next Run Statement Activity data - " + ex.Message);
util = null;
}
}
protected void btnRemove_Click(object sender, ImageClickEventArgs e)
{
try
{
hdnPageNumber.Value = "1";
ImageButton btnRemove = (ImageButton)sender;
GridViewRow gvr = ((ImageButton)sender).NamingContainer as GridViewRow;
string levelFlag = (gvr.FindControl("hdnLevelFlag") as HiddenField).Value;
string code = (gvr.FindControl("lblCode") as Label).Text;
string stmtPeriodId = (gvr.FindControl("lblStmtPeriodId") as Label).Text;
string loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
royaltorActivityBL = new RoyaltorActivityBL();
/* WOS-389 - changes - modified by Harish
* DataSet activityData = royaltorActivityBL.UpdateRemoveFromRun(levelFlag, code, loggedUserID, stmtPeriodId, out nextRunTime, out errorId);*/
DataSet activityData = royaltorActivityBL.UpdateRemoveFromRun(levelFlag, code, loggedUserID, stmtPeriodId, out errorId);
royaltorActivityBL = null;
mpeRoyActivity.Show();
if (activityData.Tables.Count != 0 && errorId != 2)
{
Session["RoyActivityData"] = activityData.Tables[0];
Utilities.PopulateGridPage(Convert.ToInt32(hdnPageNumber.Value), activityData.Tables[0], gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else if (activityData.Tables.Count == 0 && errorId != 2)
{
Utilities.PopulateGridPage(Convert.ToInt32(hdnPageNumber.Value), dtEmpty, gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else
{
util = new Utilities();
util.GenericExceptionHandler("Error in loading the activity screen grid data.");
util = null;
}
hdnIsActivityChanged.Value = "Y";
}
catch (Exception ex)
{
util = new Utilities();
util.GenericExceptionHandler("Error in removing a royaltor/owner group from next run - " + ex.Message);
util = null;
}
}
protected void btnRetry_Click(object sender, ImageClickEventArgs e)
{
try
{
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
hdnPageNumber.Value = "1";
ImageButton btnRetry = (ImageButton)sender;
GridViewRow gvr = ((ImageButton)sender).NamingContainer as GridViewRow;
string levelFlag = (gvr.FindControl("hdnLevelFlag") as HiddenField).Value;
string code = (gvr.FindControl("lblCode") as Label).Text;
string stmtPeriodId = (gvr.FindControl("lblStmtPeriodId") as Label).Text;
string retry = (gvr.FindControl("lblRetry") as Label).Text;
string detailFlag = (gvr.FindControl("hdnDetailFlag") as HiddenField).Value;
string loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
royaltorActivityBL = new RoyaltorActivityBL();
DataSet activityData = royaltorActivityBL.SetRetry(levelFlag, code, retry, detailFlag, loggedUserID, stmtPeriodId, out errorId);
royaltorActivityBL = null;
if (activityData.Tables.Count != 0 && errorId != 2)
{
Session["RoyActivityData"] = activityData.Tables[0];
Utilities.PopulateGridPage(1, activityData.Tables[0], gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else if (activityData.Tables.Count == 0 && errorId != 2)
{
Utilities.PopulateGridPage(1, activityData.Tables[0], gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else
{
ExceptionHandler("Error in loading the activity screen grid data.", string.Empty);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in removing a royaltor/owner group from next run.", ex.Message);
}
}
protected void btnRetryAll_Click(object sender, ImageClickEventArgs e)
{
try
{
hdnPageNumber.Value = "1";
List <string> stmtsToRetry = new List <string>();
string levelFlag;
string code;
string stmtPeriodId;
string loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
string retry;
string detailFlag;
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
//WUIN-38
if (Session["RoyActivityData"] == null)
{
return;
}
DataTable dtRoyActivityData = Session["RoyActivityData"] as DataTable;
if (dtRoyActivityData.Rows.Count == 0)
{
return;
}
foreach (DataRow row in dtRoyActivityData.Rows)
{
retry = row["royaltor_stmt_flag"].ToString();
detailFlag = row["dtl_file_flag"].ToString();
if (retry == "E" || detailFlag == "E")
{
levelFlag = row["level_flag"].ToString();
code = row["code"].ToString();
stmtPeriodId = row["stmt_period_id"].ToString();
stmtsToRetry.Add(levelFlag + "," + code + "," + stmtPeriodId + "," + retry + "," + detailFlag);
}
}
//foreach (GridViewRow row in gvRoyActivity.Rows)
//{
// retry = (row.FindControl("lblRetry") as Label).Text;
// if (retry == "E")
// {
// levelFlag = (row.FindControl("hdnLevelFlag") as HiddenField).Value;
// code = (row.FindControl("lblCode") as Label).Text;
// stmtPeriodId = (row.FindControl("lblStmtPeriodId") as Label).Text;
// stmtsToRetry.Add(levelFlag + "," + code + "," + stmtPeriodId);
// }
//}
royaltorActivityBL = new RoyaltorActivityBL();
DataSet activityData = royaltorActivityBL.RetryAll(stmtsToRetry.ToArray(), loggedUserID, out errorId);
royaltorActivityBL = null;
if (activityData.Tables.Count != 0 && errorId != 2)
{
Session["RoyActivityData"] = activityData.Tables[0];
Utilities.PopulateGridPage(1, activityData.Tables[0], gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else if (activityData.Tables.Count == 0 && errorId != 2)
{
Utilities.PopulateGridPage(1, activityData.Tables[0], gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else
{
ExceptionHandler("Error in loading the activity screen grid data.", string.Empty);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in removing royaltor/owner groups from next run.", ex.Message);
}
}
protected void btnRemoveAll_Click(object sender, ImageClickEventArgs e)
{
try
{
hdnPageNumber.Value = "1";
List <string> stmtsToRemove = new List <string>();
string levelFlag;
string code;
string stmtPeriodId;
string loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
string canBeRemoved;
//WUIN-38
if (Session["RoyActivityData"] == null)
{
return;
}
DataTable dtRoyActivityData = Session["RoyActivityData"] as DataTable;
if (dtRoyActivityData.Rows.Count == 0)
{
return;
}
foreach (DataRow row in dtRoyActivityData.Rows)
{
canBeRemoved = row["remove_from_run"].ToString();
if (canBeRemoved == "Y")
{
levelFlag = row["level_flag"].ToString();
code = row["code"].ToString();
stmtPeriodId = row["stmt_period_id"].ToString();
stmtsToRemove.Add(levelFlag + "," + code + "," + stmtPeriodId);
}
}
//foreach (GridViewRow row in gvRoyActivity.Rows)
//{
// canBeRemoved = (row.FindControl("lblCanBeRemoved") as Label).Text;
// if (canBeRemoved == "Y")
// {
// levelFlag = (row.FindControl("hdnLevelFlag") as HiddenField).Value;
// code = (row.FindControl("lblCode") as Label).Text;
// stmtPeriodId = (row.FindControl("lblStmtPeriodId") as Label).Text;
// stmtsToRemove.Add(levelFlag + "," + code + "," + stmtPeriodId);
// }
//}
royaltorActivityBL = new RoyaltorActivityBL();
DataSet activityData = royaltorActivityBL.RemoveAllFromRun(stmtsToRemove.ToArray(), loggedUserID, out errorId);
royaltorActivityBL = null;
//JIRA-1133 changes made by Harshika on 09-01-2020 --start
mpeRoyActivity.Show();
//JIRA-1133 changes made by Harshika on 09-01-2020 --end
if (activityData.Tables.Count != 0 && errorId != 2)
{
Session["RoyActivityData"] = activityData.Tables[0];
Utilities.PopulateGridPage(Convert.ToInt32(hdnPageNumber.Value), activityData.Tables[0], gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else if (activityData.Tables.Count == 0 && errorId != 2)
{
Utilities.PopulateGridPage(Convert.ToInt32(hdnPageNumber.Value), dtEmpty, gridDefaultPageSize, gvRoyActivity, dtEmpty, rptPager);
}
else
{
ExceptionHandler("Error in loading the activity screen grid data.", string.Empty);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in removing royaltor/owner groups from next run.", ex.Message);
}
}
