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); } }