private void LoadDropdowns()
{
royaltorGroupingBL = new RoyaltorGroupingsBL();
DataSet royaltorGroupingData = royaltorGroupingBL.GetRoyaltorGroupings(out errorId);
royaltorGroupingBL = null;
if (royaltorGroupingData.Tables.Count != 0 && errorId != 2)
{
ddlRoyaltorGroupType.DataTextField = "ROYALTOR_GROUP_TYPE_DESC";
ddlRoyaltorGroupType.DataValueField = "ROYALTOR_GROUP_TYPE_CODE";
ddlRoyaltorGroupType.DataSource = royaltorGroupingData.Tables[0];
ddlRoyaltorGroupType.DataBind();
ddlRoyaltorGroupType.Items.Insert(0, new ListItem("-"));
Session["royaltorGroupingData"] = royaltorGroupingData;
}
else if (royaltorGroupingData.Tables.Count == 0 && errorId != 2)
{
ddlRoyaltorGroupType.Items.Insert(0, new ListItem("-"));
}
else
{
ExceptionHandler("Error in loading grouping type dropdown.", string.Empty);
}
LoadInitialGridData();
}
protected void btnGenAllSummaries_Click(object sender, EventArgs e)
{
try
{
loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
royaltorGroupingBL = new RoyaltorGroupingsBL();
royaltorGroupingBL.GenerateAllGroupSummaries(loggedUserID, out errorId);
royaltorGroupingBL = null;
if (errorId == 1)
{
msgView.SetMessage("One or more Summaries cannot be generated. Summary request is in progress for the rest. The reports will be available when generated.", MessageType.Warning, PositionType.Auto);
}
else if (errorId == 2)
{
ExceptionHandler("Error in setting flag to generate all summaries", string.Empty);
}
else
{
msgView.SetMessage("Summary request is in progress. The reports will be available when generated.", MessageType.Warning, PositionType.Auto);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in setting flag to generate all summaries", ex.Message);
}
}
protected void btnGenSummForGroup_Click(object sender, EventArgs e)
{
try
{
//validation - check if in group grid has rows
if (gvGroupIn.Rows.Count == 0)
{
msgView.SetMessage("No Royaltors in the group to generate the Summary!", MessageType.Warning, PositionType.Auto);
return;
}
groupId = Convert.ToInt32(txtRoyaltorGroupType.Text.Substring(0, txtRoyaltorGroupType.Text.IndexOf("-")));
loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
royaltorGroupingBL = new RoyaltorGroupingsBL();
royaltorGroupingBL.GenerateGroupSummaries(loggedUserID, groupId, out errorId);
royaltorGroupingBL = null;
if (errorId == 1)
{
msgView.SetMessage("Summary cannot be generated. One or more Royaltors do not have the correct status.", MessageType.Warning, PositionType.Auto);
}
else if (errorId == 2)
{
ExceptionHandler("Error in setting flag to generate group summaries", string.Empty);
}
else
{
msgView.SetMessage("Summary request is in progress. The reports will be available when generated.", MessageType.Warning, PositionType.Auto);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in setting flag to generate group summaries", ex.Message);
}
}
protected void btnAddRoyaltor_Click(object sender, ImageClickEventArgs e)
{
try
{
hdnPageNumber.Value = "1";
string userCode = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
int selectdRoyaltorId;
royaltorGroupingBL = new RoyaltorGroupingsBL();
groupTypeCode = Convert.ToInt32(ddlRoyaltorGroupType.SelectedValue);
groupId = Convert.ToInt32(txtRoyaltorGroupType.Text.Substring(0, txtRoyaltorGroupType.Text.IndexOf("-")));
if (Session["selectdRoyaltorId"] == null)
{
selectdRoyaltorId = Convert.ToInt32(txtRoyaltorGroupType.Text.Substring(0, txtRoyaltorGroupType.Text.IndexOf("-")));
}
else
{
selectdRoyaltorId = Convert.ToInt32(Session["selectdRoyaltorId"]);
}
List <Int32> royaltorIds = new List <Int32>();
CheckBox cbAddRoyaltors;
foreach (GridViewRow gridrow in gvGroupOut.Rows)
{
cbAddRoyaltors = (CheckBox)gridrow.FindControl("cbAddRoyaltors");
if (cbAddRoyaltors.Checked)
{
royaltorId = Convert.ToInt32((gridrow.FindControl("lblRoyaltorId") as Label).Text);
royaltorIds.Add(royaltorId);
}
}
if (royaltorIds.Count > 0)
{
DataSet royaltorGroupingData = royaltorGroupingBL.AddRoyaltorToGroup(groupTypeCode, groupId, selectdRoyaltorId, royaltorIds.ToArray(), userCode, out errorId);
royaltorGroupingBL = null;
BindGrids(royaltorGroupingData);
UpdateSearchList(royaltorGroupingData);
Session["FuzzyRoyGrpMaintGroupInBoxList"] = royaltorGroupingData.Tables[0];
Session["FuzzyRoyGrpMaintGroupOutBoxList"] = royaltorGroupingData.Tables[7]; //Harish 05-01-2018 - reverted it back to 2 as it was correct(as discussed with Janet)
Session["groupOutDataPaging"] = royaltorGroupingData.Tables[1]; //Harish 05-01-2018 - WUIN-380 - paging changes
txtGroupOutBox.Text = string.Empty;
txtGroupInBox.Text = string.Empty;
}
else
{
ScrollOutGrid();
msgView.SetMessage("Please select a royaltor from 'Out of the Group' list",
MessageType.Warning, PositionType.Auto);
}
}
catch (Exception ex)
{
ExceptionHandler("Error in adding royaltor to group", ex.Message);
}
}
private void LoadGridData(Int32 groupTypeCode, Int32 groupId)
{
royaltorGroupingBL = new RoyaltorGroupingsBL();
DataSet royaltorGroupingData = royaltorGroupingBL.GetRoyaltorGroupingsInOutData(groupTypeCode, groupId, out errorId);
royaltorGroupingBL = null;
hdnPageNumber.Value = "1";
BindGrids(royaltorGroupingData);
Session["FuzzyRoyGrpMaintGroupInBoxList"] = royaltorGroupingData.Tables[0];
Session["FuzzyRoyGrpMaintGroupOutBoxList"] = royaltorGroupingData.Tables[2]; //Harish 05-01-2018 - reverted it back to 2 as it was correct(as discussed with Janet)
Session["groupOutDataPaging"] = royaltorGroupingData.Tables[1]; //Harish 05-01-2018 - WUIN-380 - paging changes
}
private void RoyaltorOutBoxSelected()
{
if (ValidateSelectedRoyaltorOut())
{
groupTypeCode = Convert.ToInt32(ddlRoyaltorGroupType.SelectedValue);
groupId = Convert.ToInt32(txtRoyaltorGroupType.Text.Substring(0, txtRoyaltorGroupType.Text.IndexOf("-")));
int selectdRoyaltorId = Convert.ToInt32(txtGroupOutBox.Text.Substring(0, txtGroupOutBox.Text.IndexOf("-")));
Session["selectdRoyaltorId"] = selectdRoyaltorId;
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
royaltorGroupingBL = new RoyaltorGroupingsBL();
DataSet royaltorGroupingData = royaltorGroupingBL.GetUpdatedOutData(groupTypeCode, groupId, selectdRoyaltorId, out errorId);
royaltorGroupingBL = null;
if (royaltorGroupingData.Tables.Count != 0 && errorId != 2)
{
gvGroupOut.DataSource = royaltorGroupingData.Tables[0];
Session["groupOutDataPaging"] = royaltorGroupingData.Tables[0]; //Harish 09-01-2018 - WUIN-380 - paging changes
Session["RoyGroupingOutData"] = royaltorGroupingData.Tables[0]; //Harish 09-01-2018 - WUIN-380 - paging changes
if (royaltorGroupingData.Tables[0].Rows.Count == 0)
{
gvGroupOut.EmptyDataText = "No data found for the selected royaltor group.";
gvGroupOut.DataBind();
gvGroupOut.SelectedIndex = -1;
}
else
{
//WOS-402 changes - Harish 06-12-2016 =============
//DataTable dt01 = royaltorGroupingData.Tables[0].Select("royaltor=" + selectdRoyaltorId).CopyToDataTable();
DataRow[] result = royaltorGroupingData.Tables[0].Select("royaltor_id = " + selectdRoyaltorId);
if (result.Length > 0)
{
//int SelectedIndex = royaltorGroupingData.Tables[0].Rows.IndexOf(result[0]);
//int pageIndex = Convert.ToInt32(Math.Truncate(Convert.ToDouble(SelectedIndex / 500)));
//gvGroupOut.PageIndex = pageIndex;
//gvGroupOut.DataBind();
//gvGroupOut.SelectedIndex = SelectedIndex - (pageIndex) * 500;
ScrollOutGrid();
ScrollInGrid();
}
}
//============== End
}
else if (royaltorGroupingData.Tables.Count == 0 && errorId != 2)
{
dtEmpty = new DataTable();
gvGroupOut.DataSource = dtEmpty;
gvGroupOut.EmptyDataText = "No data found for the selected royaltor group.";
gvGroupOut.DataBind();
Session["groupOutDataPaging"] = royaltorGroupingData.Tables[0];//Harish 09-01-2018 - WUIN-380 - paging changes
}
else
{
ExceptionHandler("Error in loading grid data.", string.Empty);
}
if (gvGroupOut.Rows.Count == 0)
{
btnAddRoyaltor.Enabled = false;
}
else
{
btnAddRoyaltor.Enabled = true;
}
/*WOS-402 changes - Harish 06-12-2016 =============
* code before changes
* foreach (GridViewRow datarow in gvGroupOut.Rows)
* {
* royaltorId = Convert.ToInt32((datarow.FindControl("lblRoyaltorId") as Label).Text);
* if (royaltorId == selectdRoyaltorId)
* {
* gvGroupOut.SelectedIndex = datarow.RowIndex;
* ScrollOutGrid();
* ScrollInGrid();
* }
* }
* */
//============== End
hdnPageNumber.Value = "1";
Utilities.PopulateGridPage(1, royaltorGroupingData.Tables[0], gridDefaultPageSize, gvGroupOut, dtEmpty, rptPager);
UserAuthorization();
}
else
{
gvGroupOut.SelectedIndex = -1;
txtGroupOutBox.Text = string.Empty;
//msgView.SetMessage("Please select a valid royaltor from the filter list",
// MessageType.Warning, PositionType.Auto);
}
}
