private void SeachAutoParticipantData()
{
AutoParticipantSession();
autoParticipantSearchBL = new AutoParticipantSearchBL();
//JIRA-1048 --Changes to handle single quote -- Start
DataSet autoPartData = autoParticipantSearchBL.SearchAutoParticipantData(txtMarketingOwner.Text.Replace("'", "").Trim(), txtWEASalesLabel.Text.Replace("'", "").Trim(), txtArtist.Text.Replace("'", "").Trim(), txtProject.Text.Replace("'", "").Trim(), out errorId);
//JIRA-1048 --Changes to handle single quote -- End
autoParticipantSearchBL = null;
if (autoPartData.Tables.Count != 0 && errorId != 2)
{
if (autoPartData.Tables[0].Rows.Count == 0 && errorId != 2)
{
dtEmpty = new DataTable();
gvAutoParticipantDtls.EmptyDataText = "No data found for the selected filter criteria";
BindGrid(autoPartData.Tables[0]);
Session["AutoParticipantData"] = null;
}
else
{
Session["AutoParticipantData"] = autoPartData.Tables[0];
BindGrid(autoPartData.Tables[0]);
if (autoPartData.Tables[0].Rows.Count == 1 && hdnIsNewRequest.Value == "Y")
{
Response.Redirect("../Participants/AutoParticipantMaintenance.aspx?autoPartId=" + autoPartData.Tables[0].Rows[0]["auto_participant_id"].ToString() + "", false);
}
}
}
else
{
ExceptionHandler("Error in fetching data", string.Empty);
}
}
private void SaveAutoParticipant(int autoPartId, string marketingOwner, string weaSalesLabel, string artist, string projectTitle)
{
string userCode = Convert.ToString(Session["UserCode"]);
marketingOwner = marketingOwner == "" ? "-" : marketingOwner.Trim().ToUpper();
weaSalesLabel = weaSalesLabel == "" ? "-" : weaSalesLabel.Trim().ToUpper();
int artistId = artist == "" ? -1 : Convert.ToInt32(artist.Split('-')[0].Trim());
int projectId = projectTitle == "" ? -1 : Convert.ToInt32(projectTitle.Split('-')[0].Trim());
//projectTitle = projectTitle == "" ? "-" : projectTitle.Split('-')[1].Trim();
projectTitle = projectTitle == "" ? "-" : projectTitle.Substring((projectTitle.IndexOf('-') + 2), (projectTitle.Length - projectTitle.IndexOf('-') - 2));
//JIRA-1048 --Changes to handle single quote -- Start
string marketingOnwerSearch = txtMarketingOwner.Text.Replace("'", "").Trim();
string weaSalesLabelSearch = txtWEASalesLabel.Text.Replace("'", "").Trim();
string artistSearch = txtArtist.Text.Replace("'", "").Trim();
string projectSearch = txtProject.Text.Replace("'", "").Trim();
//JIRA-1048 --Changes to handle single quote -- End
autoParticipantSearchBL = new AutoParticipantSearchBL();
DataSet autoParticipantData = autoParticipantSearchBL.AddUpdateAutoParticipant(autoPartId, marketingOwner, weaSalesLabel,
artistId, projectId, projectTitle, marketingOnwerSearch, weaSalesLabelSearch, artistSearch, projectSearch, userCode, out newAutoPartId, out errorId);
autoParticipantSearchBL = null;
if (errorId == 0)
{
if (autoPartId == 0 && newAutoPartId != 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "NewAutoParticipSave", "RedirectToAutoParticipMaint(" + newAutoPartId + ");", true);
}
else
{
if (autoParticipantData.Tables[0].Rows.Count == 0 && errorId != 2)
{
dtEmpty = new DataTable();
gvAutoParticipantDtls.EmptyDataText = "No data found for the selected filter criteria";
BindGrid(autoParticipantData.Tables[0]);
Session["AutoParticipantData"] = null;
}
else
{
Session["AutoParticipantData"] = autoParticipantData.Tables[0];
BindGrid(autoParticipantData.Tables[0]);
}
msgView.SetMessage("Participation Group updated successfully.", MessageType.Success, PositionType.Auto);
}
}
else if (errorId == 1)
{
msgView.SetMessage("This Participant Group already exists.", MessageType.Warning, PositionType.Auto);
return;
}
else
{
msgView.SetMessage("Failed to save Participation Group.", MessageType.Warning, PositionType.Auto);
return;
}
}
