protected void valBalanceDate_ServerValidate(object source, ServerValidateEventArgs args)
{
if (txtBalanceDate.Text.Trim() != "__/____" && txtBalanceDate.Text.Trim() != string.Empty)
{
if (txtBalanceDate.Text.Contains("_"))
{
args.IsValid = false;
msgView.SetMessage("Please enter a valid date in MM/YYYY format", MessageType.Warning, PositionType.Auto);
valBalanceDate.ToolTip = "Please enter a valid date in MM/YYYY format";
return;
}
else
{
RoyaltorBalanceBL royaltorBalanceBL = new RoyaltorBalanceBL();
royaltorList = royaltorBalanceBL.GetRoyaltorDate(txtRoyaltor.Text.Split('-')[0].ToString().Trim(), out errorId);
string monthCode = Convert.ToString(royaltorList.Tables[0].Rows[0]["month_code"]);
Int32 dateYear = Convert.ToInt32(txtBalanceDate.Text.Replace('_', ' ').Split('/')[1].Trim());
Int32 dateMonth = Convert.ToInt32(txtBalanceDate.Text.Replace('_', ' ').Split('/')[0].Trim());
if (!(dateMonth > 0 && dateMonth < 13) || !(dateYear > 1900))
{
args.IsValid = false;
msgView.SetMessage("Please enter a valid date in MM/YYYY format", MessageType.Warning, PositionType.Auto);
valBalanceDate.ToolTip = "Please enter a valid date in MM/YYYY format";
return;
}
else if (dateYear > DateTime.Now.Year || (dateMonth > DateTime.Now.Month && dateYear >= DateTime.Now.Year))
{
args.IsValid = false;
msgView.SetMessage("Date should not be greater than Today", MessageType.Warning, PositionType.Auto);
valBalanceDate.ToolTip = "Date should not be greater than Today";
return;
}
else if (royaltorList.Tables[0].Rows.Count > 0 && !string.IsNullOrEmpty(monthCode))
{
if (Convert.ToInt32(monthCode) >= Convert.ToInt32((txtBalanceDate.Text.Split('/')[1] + txtBalanceDate.Text.Split('/')[0]).Replace("/", "")))
{
args.IsValid = false;
msgView.SetMessage("Should be a date greater than latest end date of statement period from Balance History", MessageType.Warning, PositionType.Auto);
valBalanceDate.ToolTip = "Should be a date greater than latest end date of statement period from Balance History";
return;
}
}
}
}
}
protected void btnHdnRoyaltor_Click(object sender, EventArgs e)
{
try
{
string voucherDate = string.Empty;
string dateType = string.Empty;
decimal broughtForward = 0, costs = 0, royaltyReserves = 0, royaltyEarnings = 0, balance = 0;
System.Globalization.DateTimeFormatInfo mfi = new
System.Globalization.DateTimeFormatInfo();
hdnRoyaltorId.Value = txtRoyaltor.Text.Split('-')[0].ToString().Trim();
Page.Validate("valGrpSave");
if (!Page.IsValid)
{
return;
}
else
{
ClearValues();
RoyaltorBalanceBL royaltorBalanceBL = new RoyaltorBalanceBL();
if (txtBalanceDate.Text.Contains("_") || txtBalanceDate.Text == string.Empty)
{
dateType = "default";
royaltorList = royaltorBalanceBL.GetSearchedData(txtRoyaltor.Text.Split('-')[0].ToString().Trim(), dateType, DateTime.Now.ToString("yyyyMM"), string.Empty, out errorId);
}
else
{
dateType = "date";
voucherDate = DateTime.DaysInMonth(Convert.ToInt32(txtBalanceDate.Text.Split('/')[1]), Convert.ToInt32(txtBalanceDate.Text.Split('/')[0])) + "-" + mfi.GetMonthName(Convert.ToInt32(txtBalanceDate.Text.Split('/')[0])).Substring(0, 3) + "-" + txtBalanceDate.Text.Split('/')[1];
royaltorList = royaltorBalanceBL.GetSearchedData(txtRoyaltor.Text.Split('-')[0].ToString().Trim(), "date", (txtBalanceDate.Text.Split('/')[1] + txtBalanceDate.Text.Split('/')[0]), voucherDate, out errorId);
}
if (royaltorList.Tables.Count > 0 && txtRoyaltor.Text.Split('-')[0].ToString().Trim() != string.Empty)
{
if (royaltorList.Tables[0].Rows.Count > 0)
{
txtBroughtForwardDate.Text = ConvertTime(Convert.ToString(royaltorList.Tables[0].Rows[0]["month_code"]));
broughtForward = Math.Round(Convert.ToDecimal(royaltorList.Tables[0].Rows[0]["closing_balance"]), 2);
txtBroughtForward.Text = ConvertAmount(broughtForward);
}
if (royaltorList.Tables[1].Rows.Count > 0 && dateType == "default")
{
costs = (Math.Round(Convert.ToDecimal(string.IsNullOrEmpty(Convert.ToString(royaltorList.Tables[1].Rows[0]["total_costs"])) ? "0" : (royaltorList.Tables[1].Rows[0]["total_costs"])), 2));
royaltyReserves = (Math.Round(Convert.ToDecimal(string.IsNullOrEmpty(Convert.ToString(royaltorList.Tables[1].Rows[0]["total_reserve_amount"])) ? "0" : (royaltorList.Tables[1].Rows[0]["total_reserve_amount"])), 2));
royaltyEarnings = Math.Round(Convert.ToDecimal(string.IsNullOrEmpty(Convert.ToString(royaltorList.Tables[1].Rows[0]["total_royalty_amount"])) ? "0" : (royaltorList.Tables[1].Rows[0]["total_royalty_amount"])), 2);
}
else if (dateType == "date" && royaltorList.Tables[1].Rows.Count > 0 && royaltorList.Tables[2].Rows.Count > 0)
{
costs = (Math.Round(Convert.ToDecimal(string.IsNullOrEmpty(Convert.ToString(royaltorList.Tables[2].Rows[0]["total_costs"])) ? "0" : (royaltorList.Tables[2].Rows[0]["total_costs"])), 2));
royaltyReserves = (Math.Round(Convert.ToDecimal(string.IsNullOrEmpty(Convert.ToString(royaltorList.Tables[1].Rows[0]["total_reserve_amount"])) ? "0" : (royaltorList.Tables[1].Rows[0]["total_reserve_amount"])), 2));
royaltyEarnings = Math.Round(Convert.ToDecimal(string.IsNullOrEmpty(Convert.ToString(royaltorList.Tables[1].Rows[0]["total_royalty_amount"])) ? "0" : (royaltorList.Tables[1].Rows[0]["total_royalty_amount"])), 2);
}
//Formula Balance = Balance Brought Forward + Royalty Earnings - Royaltor Reserves - Costs
balance = broughtForward + royaltyEarnings - royaltyReserves - costs;
txtBalanceFinalDate.Text = txtBalanceDate.Text.Contains("_") ? DateTime.Now.ToString("MMM-yyyy") : (mfi.GetMonthName(Convert.ToInt32(txtBalanceDate.Text.Split('/')[0])).Substring(0, 3) + "-" + txtBalanceDate.Text.Split('/')[1]);
txtBalanceFinal.Text = ConvertAmount(balance);
txtRoyaltyEarnings.Text = ConvertAmount(royaltyEarnings);
//WUIN-556 Multipled value with -1 for costs and reserves
txtRoyaltyReserves.Text = ConvertAmount(royaltyReserves * -1);
txtCosts.Text = ConvertAmount(costs * -1);
}
}
}
catch (Exception ex)
{
ExceptionHandler("Error in search.", ex.Message);
}
}
