//JIRA-746 CHanges by Ravi on 05/03/2019 -- End
protected void gvCatalogueDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "dblClk")
{
GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
string catNo = (row.FindControl("lblCatNo") as Label).Text;
//string trackListingId = (row.FindControl("hdnTrackListingId") as HiddenField).Value;
string catnoLegacy = string.Empty;
missingParticipantsBL = new MissingParticipantsBL();
string isTrackListingExist = missingParticipantsBL.IsTrackListingExist(catNo, out catnoLegacy, out errorId);
missingParticipantsBL = null;
//WUIN-502 - change
//display Track Listing screen if CATNO.LEGACY = 'N' and Track Listing exists for CATNO
//Else display Catalogue Maintenance
if (isTrackListingExist == "Y" && catnoLegacy == "N")
{
Response.Redirect("../Participants/TrackListing.aspx?CatNo=" + catNo + "", false);
}
else
{
Response.Redirect("../Participants/CatalogueMaintenance.aspx?CatNo=" + catNo + "", false);
}
}
}
catch (Exception ex)
{
ExceptionHandler("Error in redirecting to track listing screen.", ex.Message);
}
}
private void BindGrid(DataTable gridData)
{
tdData.Style.Remove("display");
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
//WUIN-215 - changes
//If search returns only one result - display Track Listing or CATNO depending on data (don't display grid for only one product)
if (gridData.Rows.Count == 1)
{
if (hdnIsNewRequest.Value != "N") //If redirected from other screen (hdnIsNewRequest.Value = "N") then just bind the data
{
string catNo = Convert.ToString(gridData.Rows[0]["catno"]);
//string trackListingId = Convert.ToString(gridData.Rows[0]["track_listing_id"]);
string catnoLegacy = string.Empty;
missingParticipantsBL = new MissingParticipantsBL();
string isTrackListingExist = missingParticipantsBL.IsTrackListingExist(catNo, out catnoLegacy, out errorId);
missingParticipantsBL = null;
//WUIN-502 - change
//display Track Listing screen if CATNO.LEGACY = 'N' and Track Listing exists for CATNO
//Else display Catalogue Maintenance
if (isTrackListingExist == "Y" && catnoLegacy == "N")
{
Response.Redirect("../Participants/TrackListing.aspx?CatNo=" + catNo + "", false);
}
else
{
Response.Redirect("../Participants/CatalogueMaintenance.aspx?CatNo=" + catNo + "", false);
}
}
else
{
gvCatalogueDetails.DataSource = gridData;
gvCatalogueDetails.DataBind();
}
}
else
{
PopulateGridPage(1, gridData);
//PopulateGridPage(hdnPageIndex.Value == "" ? 1 : Convert.ToInt32(hdnPageIndex.Value));
}
}
private void LoadSearchedData()
{
//validate
//if (!Page.IsValid)
//{
// msgView.SetMessage("Invalid search input!", MessageType.Warning, PositionType.Auto);
// return;
//}
string teamResponsibility = string.Empty;
string teamResponsibilityTrack = string.Empty;
string mngrResponsibility = string.Empty;
string mngrResponsibilityTrack = string.Empty;
string catnoStatusCode = string.Empty;
string trackStatusCode = string.Empty;
string startDate = string.Empty;
string endDate = string.Empty;
string configuration = string.Empty;
if (ddlTeamResponsibility.SelectedIndex > 0)
{
teamResponsibility = ddlTeamResponsibility.SelectedValue;
}
if (ddlTeamResponsibilitybyTrackLevel.SelectedIndex > 0)
{
teamResponsibilityTrack = ddlTeamResponsibilitybyTrackLevel.SelectedValue;
}
if (ddlManagerResponsibility.SelectedIndex > 0)
{
mngrResponsibility = ddlManagerResponsibility.SelectedValue;
}
if (ddlManagerResponsibilitybyTrackLevel.SelectedIndex > 0)
{
mngrResponsibilityTrack = ddlManagerResponsibilitybyTrackLevel.SelectedValue;
}
if (ddlCatnoStatus.SelectedIndex > 0)
{
catnoStatusCode = ddlCatnoStatus.SelectedValue;
}
if (ddlTrackStatus.SelectedIndex > 0)
{
trackStatusCode = ddlTrackStatus.SelectedValue;
}
if (ddlConfiguration.SelectedIndex > 0)
{
configuration = ddlConfiguration.SelectedValue;
}
if (txtStartDate.Text != "__/____")
{
startDate = txtStartDate.Text.Split('/')[1].ToString() + txtStartDate.Text.Split('/')[0].ToString();
}
if (txtEndDate.Text != "__/____")
{
endDate = txtEndDate.Text.Split('/')[1].ToString() + txtEndDate.Text.Split('/')[0].ToString();;
}
missingParticipantsBL = new MissingParticipantsBL();
//JIRA-1048 Changes to handle single quote while searching --Start
DataSet initialData = missingParticipantsBL.GetSearchedData(txtCatalogueNo.Text.Replace("'", "").Trim().ToUpper(), txtTitle.Text.Replace("'", "").Trim(), txtArtist.Text.Replace("'", "").Trim(),
configuration, teamResponsibility, teamResponsibilityTrack, mngrResponsibility, mngrResponsibilityTrack, startDate, ddlCompareStartDate.SelectedValue, endDate, ddlCompareEndDate.SelectedValue, catnoStatusCode, trackStatusCode, txtValueThreshold.Text.Trim(), txtISRC.Text.Replace("'", "").Trim(), out errorId);
//JIRA-1048 Changes to handle single quote while searching --End
missingParticipantsBL = null;
if (initialData.Tables.Count != 0 && errorId != 2)
{
Session["MissingPartcipantsData"] = initialData.Tables[0];
gvCatalogueDetails.PageIndex = 0;
BindGrid(initialData.Tables[0]);
}
else
{
ExceptionHandler("Error in fetching data", string.Empty);
}
}
private void LoadData()
{
missingParticipantsBL = new MissingParticipantsBL();
DataSet initialData = missingParticipantsBL.GetInitialData(out errorId);
missingParticipantsBL = null;
if (initialData.Tables.Count != 0 && errorId != 2)
{
//Session["MissingPartcipantsData"] = initialData.Tables[0];
//BindGrid(initialData.Tables[0]);
ddlTeamResponsibility.DataSource = initialData.Tables[0];
ddlTeamResponsibility.DataTextField = "responsibility_desc";
ddlTeamResponsibility.DataValueField = "responsibility_code";
ddlTeamResponsibility.DataBind();
ddlTeamResponsibility.Items.Insert(0, new ListItem("-"));
ddlTeamResponsibilitybyTrackLevel.DataSource = initialData.Tables[0];
ddlTeamResponsibilitybyTrackLevel.DataTextField = "responsibility_desc";
ddlTeamResponsibilitybyTrackLevel.DataValueField = "responsibility_code";
ddlTeamResponsibilitybyTrackLevel.DataBind();
ddlTeamResponsibilitybyTrackLevel.Items.Insert(0, new ListItem("-"));
ddlManagerResponsibility.DataSource = initialData.Tables[0];
ddlManagerResponsibility.DataTextField = "responsibility_desc";
ddlManagerResponsibility.DataValueField = "responsibility_code";
ddlManagerResponsibility.DataBind();
ddlManagerResponsibility.Items.Insert(0, new ListItem("-"));
ddlManagerResponsibilitybyTrackLevel.DataSource = initialData.Tables[0];
ddlManagerResponsibilitybyTrackLevel.DataTextField = "responsibility_desc";
ddlManagerResponsibilitybyTrackLevel.DataValueField = "responsibility_code";
ddlManagerResponsibilitybyTrackLevel.DataBind();
ddlManagerResponsibilitybyTrackLevel.Items.Insert(0, new ListItem("-"));
ddlCatnoStatus.DataSource = initialData.Tables[1];
ddlCatnoStatus.DataTextField = "status_desc";
ddlCatnoStatus.DataValueField = "status_code";
ddlCatnoStatus.DataBind();
ddlCatnoStatus.Items.Insert(0, new ListItem("-"));
ddlTrackStatus.DataSource = initialData.Tables[3];
ddlTrackStatus.DataTextField = "status_desc";
ddlTrackStatus.DataValueField = "status_code";
ddlTrackStatus.DataBind();
ddlTrackStatus.Items.Insert(0, new ListItem("-"));
ddlConfiguration.DataTextField = "config_desc";
ddlConfiguration.DataValueField = "config_group_code";
ddlConfiguration.DataSource = initialData.Tables[2];
ddlConfiguration.DataBind();
ddlConfiguration.Items.Insert(0, new ListItem("-", null));
}
else
{
ExceptionHandler("Error in fetching data", string.Empty);
}
if (Request.QueryString != null && Request.QueryString.Count > 0)
{
hdnIsNewRequest.Value = Request.QueryString[0];
if (hdnIsNewRequest.Value == "N")
{
if (Session["MPSearchedFilters"] != null)
{
DataTable dtSearchedFilters = Session["MPSearchedFilters"] as DataTable;
foreach (DataRow dRow in dtSearchedFilters.Rows)
{
if (dRow["filter_name"].ToString() == "txtCatalogueNo")
{
txtCatalogueNo.Text = dRow["filter_value"].ToString();
}
else if (dRow["filter_name"].ToString() == "txtTitle")
{
txtTitle.Text = dRow["filter_value"].ToString();
}
else if (dRow["filter_name"].ToString() == "txtISRC")
{
txtISRC.Text = dRow["filter_value"].ToString();
}
else if (dRow["filter_name"].ToString() == "txtArtist")
{
txtArtist.Text = dRow["filter_value"].ToString();
}
else if (dRow["filter_name"].ToString() == "ddlConfiguration")
{
ddlConfiguration.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "ddlTeamResponsibility")
{
ddlTeamResponsibility.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "ddlTeamResponsibilitybyTrackLevel")
{
ddlTeamResponsibilitybyTrackLevel.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "ddlManagerResponsibility")
{
ddlManagerResponsibility.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "ddlManagerResponsibilitybyTrackLevel")
{
ddlManagerResponsibilitybyTrackLevel.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "ddlCatnoStatus")
{
ddlCatnoStatus.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "ddlTrackStatus")
{
ddlTrackStatus.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "ddlCompareStartDate")
{
ddlCompareStartDate.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "txtStartDate")
{
txtStartDate.Text = dRow["filter_value"].ToString();
}
else if (dRow["filter_name"].ToString() == "ddlCompareEndDate")
{
ddlCompareEndDate.Items.FindByValue(dRow["filter_value"].ToString()).Selected = true;
}
else if (dRow["filter_name"].ToString() == "txtEndDate")
{
txtEndDate.Text = dRow["filter_value"].ToString();
}
else if (dRow["filter_name"].ToString() == "txtValueThreshold")
{
txtValueThreshold.Text = dRow["filter_value"].ToString();
}
}
LoadSearchedData();
}
}
}
}
