private void LoadInitialData(string royaltorId)
{
royContractEscHistoryBL = new RoyContractEscHistoryBL();
DataSet initialData = royContractEscHistoryBL.GetInitialData((royaltorId == null ? Global.DBNullParamValue : royaltorId), out errorId);
royContractEscHistoryBL = null;
if (errorId != 2)
{
if (royaltorId != null)
{
//populate royaltor for the royaltor id
if (Session["FuzzySearchAllRoyListWithOwnerCode"] == null)
{
DataSet dsList = new FuzzySearchBL().GetFuzzySearchList("GetAllRoyaltorListWithOwnerCode", out errorId);
Session["FuzzySearchAllRoyListWithOwnerCode"] = dsList.Tables[0];
}
DataRow[] filteredRow = ((DataTable)Session["FuzzySearchAllRoyListWithOwnerCode"]).Select("royaltor_id = '" + royaltorId + "'");
txtRoyaltor.Text = filteredRow[0]["royaltor"].ToString();
ddlEscCode.DataSource = initialData.Tables["EscCodeList"];
ddlEscCode.DataTextField = "item_text";
ddlEscCode.DataValueField = "item_value";
ddlEscCode.DataBind();
if (initialData.Tables["EscCodeList"].Rows.Count == 0)
{
ddlEscCode.Items.Insert(0, new ListItem("-"));
}
if (initialData.Tables["EscCodeList"].Rows.Count > 0)
{
string minEscCode = Convert.ToString(initialData.Tables["EscCodeList"].Compute("min([item_value])", string.Empty));
ddlEscCode.SelectedValue = minEscCode.ToString();
}
if (initialData.Tables["EscHistory"].Rows.Count == 0)
{
gvEscHistory.EmptyDataText = "No data found for the selected royaltor and escalation code";
}
Session["EscHistoryData"] = initialData.Tables["EscHistory"];
gvEscHistory.DataSource = initialData.Tables["EscHistory"];
gvEscHistory.DataBind();
PopulateTotalSales(initialData.Tables["EscHistory"]);
}
else
{
txtRoyaltor.Text = string.Empty;
LoadEmptyGrid();
}
UserAuthorization();
}
else
{
ExceptionHandler("Error in loading grid data", string.Empty);
}
}
protected void ddlEscCode_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataSet escHistoryData;
royaltorId = txtRoyaltor.Text.Substring(0, txtRoyaltor.Text.IndexOf("-") - 1);
if (btnHistorySummary.Text == "History Summary")
{
royContractEscHistoryBL = new RoyContractEscHistoryBL();
escHistoryData = royContractEscHistoryBL.GetEscHistory(royaltorId, ddlEscCode.SelectedValue, out errorId);
royContractEscHistoryBL = null;
}
else
{
enableGridEdit = false;
royContractEscHistoryBL = new RoyContractEscHistoryBL();
escHistoryData = royContractEscHistoryBL.GetEscHistorySummary(royaltorId, ddlEscCode.SelectedValue, out errorId);
royContractEscHistoryBL = null;
}
if (errorId == 2)
{
ExceptionHandler("Error in loading grid data", string.Empty);
return;
}
if (escHistoryData.Tables.Count != 0)
{
if (escHistoryData.Tables[0].Rows.Count == 0)
{
gvEscHistory.EmptyDataText = "No data found for the selected royaltor and escalation code";
}
gvEscHistory.DataSource = escHistoryData.Tables[0];
gvEscHistory.DataBind();
PopulateTotalSales(escHistoryData.Tables[0]);
}
else if (escHistoryData.Tables.Count == 0)
{
dtEmpty = new DataTable();
gvEscHistory.DataSource = dtEmpty;
gvEscHistory.EmptyDataText = "No data found for the selected royaltor and escalation code";
gvEscHistory.DataBind();
}
UserAuthorization();
}
catch (Exception ex)
{
ExceptionHandler("Error in loading grid data", ex.Message);
}
}
private void SaveEscHistoryDetails(GridViewRow gvr)
{
if (!Page.IsValid)
{
msgView.SetMessage("Invalid or missing data!", MessageType.Warning, PositionType.Auto);
return;
}
string royaltorId = (gvr.FindControl("hdnRoyaltorId") as HiddenField).Value;
string escCode = (gvr.FindControl("hdnEscCode") as HiddenField).Value;
string sellerGrpCode = (gvr.FindControl("hdnSellerGrpCode") as HiddenField).Value;
string configGrpCode = (gvr.FindControl("hdnConfigGrpCode") as HiddenField).Value;
string priceGrpCode = (gvr.FindControl("hdnPriceGrpCode") as HiddenField).Value;
string sales = (gvr.FindControl("txtSales") as TextBox).Text;
string adjSales = (gvr.FindControl("txtAdjSales") as TextBox).Text;
royContractEscHistoryBL = new RoyContractEscHistoryBL();
DataSet escHistory = royContractEscHistoryBL.SaveEscHistory(royaltorId, escCode, sellerGrpCode, priceGrpCode, configGrpCode, sales, adjSales, out errorId);
royContractEscHistoryBL = null;
LoadGridData(escHistory, errorId);
}
//JIRA-746 CHanges by Ravi on 05/03/2019 -- End
//JIRA-908 Changes by Ravi on 12/02/2019 -- Start
protected void btnYes_Click(object sender, EventArgs e)
{
try
{
string royaltorId = hdnDeleteRoyaltorId.Value;
string escCode = hdnDeleteEscCode.Value;
string sellerGrpCode = hdnDeleteSellerGrpCode.Value;
string priceGrpCode = hdnDeletePriceGrpCode.Value;
string configGrpCode = hdnDeleteConfigGrpCode.Value;
royContractEscHistoryBL = new RoyContractEscHistoryBL();
DataSet escHistory = royContractEscHistoryBL.DeleteEscHistory(royaltorId, escCode, sellerGrpCode, priceGrpCode, configGrpCode, out errorId);
royContractEscHistoryBL = null;
LoadGridData(escHistory, errorId);
hdnDeleteRoyaltorId.Value = "";
hdnDeleteEscCode.Value = "";
hdnDeleteSellerGrpCode.Value = "";
hdnDeletePriceGrpCode.Value = "";
hdnDeleteConfigGrpCode.Value = "";
}
catch (Exception ex)
{
ExceptionHandler("Error in deleting grid data", ex.Message);
}
}
