private void InsertExchangeRateFactor()
{
//Validate
Page.Validate("valInsertExchangeRates");
if (!Page.IsValid)
{
mpeSaveUndo.Hide();
msgView.SetMessage("Payment exchange rate details not saved – invalid or missing data!", MessageType.Warning, PositionType.Auto);
return;
}
string userCode = Convert.ToString(Session["UserCode"]);
int month = Convert.ToInt32(txtPaymentMonth.Text.Split('/')[0].ToString());
int year = Convert.ToInt32(txtPaymentMonth.Text.Split('/')[1].ToString());
string companyCode = ddlCompany.SelectedValue == "" ? txtCompany.Text.Split('-')[0].ToString().Trim() : ddlCompany.SelectedValue;
paymentExchangeRatesBL = new PaymentExchangeRatesBL();
DataSet updatedData = paymentExchangeRatesBL.InsertPaymentExchangeRates(companyCode, txtCurrency.Text.ToUpper(), month, year, Convert.ToDouble(txtExchangeRate.Text), userCode, out errorId);
paymentExchangeRatesBL = null;
if (errorId == 3)
{
msgView.SetMessage("Invalid month and year combination. Failed to save payment exchange rate details.", MessageType.Warning, PositionType.Auto);
}
else if (errorId == 4)
{
msgView.SetMessage("Invalid currency code. Failed to save payment exchange rate details. ", MessageType.Warning, PositionType.Auto);
}
else if (errorId == 1)
{
msgView.SetMessage("Payment exchange rate exists for this payment month and currency code.", MessageType.Success, PositionType.Auto);
}
else if (updatedData.Tables.Count != 0 && errorId != 2)
{
Session["ExchangeRateFactorData"] = updatedData.Tables[0];
gvExchangeRateDetails.PageIndex = 0;
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
BindGrid(updatedData.Tables[0]);
hdnInsertDataNotSaved.Value = "N";
txtPaymentMonth.Text = string.Empty;
txtExchangeRate.Text = string.Empty;
txtCurrency.Text = string.Empty;
gvExchangeRateDetails.PageIndex = 0;
msgView.SetMessage("Payment exchange rate created successfully.", MessageType.Success, PositionType.Auto);
}
else
{
msgView.SetMessage("Failed to save payment exchange rate details.", MessageType.Warning, PositionType.Auto);
}
}
protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlCompany.SelectedIndex > 0)
{
txtCurrency.Enabled = true;
txtExchangeRate.Enabled = true;
txtPaymentMonth.Enabled = true;
paymentExchangeRatesBL = new PaymentExchangeRatesBL();
DataSet paymentExchangeRateData = paymentExchangeRatesBL.GetPaymentExchangeRateData(ddlCompany.SelectedValue, out errorId);
paymentExchangeRatesBL = null;
if (paymentExchangeRateData.Tables.Count != 0 && errorId != 2)
{
Session["ExchangeRateFactorData"] = paymentExchangeRateData.Tables[0];
gvExchangeRateDetails.PageIndex = 0;
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
BindGrid(paymentExchangeRateData.Tables[0]);
}
else
{
ExceptionHandler("Error in fetching data", string.Empty);
}
}
else
{
txtCurrency.Enabled = false;
txtExchangeRate.Enabled = false;
txtPaymentMonth.Enabled = false;
imgBtnInsert.Enabled = false;
dtEmpty = new DataTable();
gvExchangeRateDetails.DataSource = dtEmpty;
gvExchangeRateDetails.DataBind();
}
}
catch (Exception ex)
{
ExceptionHandler("Error in selecting company.", ex.Message);
}
}
private void UpdateExchangeRateFactor()
{
if (!string.IsNullOrEmpty(hdnGridRowSelectedPrvious.Value))
{
string userCode = Convert.ToString(Session["UserCode"]);
int rowIndex = Convert.ToInt32(hdnGridRowSelectedPrvious.Value);
//Calculate the rowindex for validation
int rowIndexValidation = (gvExchangeRateDetails.PageIndex * gvExchangeRateDetails.PageSize) + rowIndex;
Page.Validate("GroupUpdate_" + rowIndexValidation + "");
if (!Page.IsValid)
{
msgView.SetMessage("Payment exchange rate details not saved – invalid or missing data!", MessageType.Warning, PositionType.Auto);
return;
}
//int rowIndex = ((GridViewRow)((ImageButton)(e.CommandSource)).NamingContainer).RowIndex;
string companyCode = ((HiddenField)gvExchangeRateDetails.Rows[rowIndex].FindControl("hdnCompanyCode")).Value;
string currencyCode = ((Label)gvExchangeRateDetails.Rows[rowIndex].FindControl("lblCurrencyCode")).Text;
string monthId = ((HiddenField)gvExchangeRateDetails.Rows[rowIndex].FindControl("hdnMonthId")).Value;
string exchangeRateFactor = ((TextBox)gvExchangeRateDetails.Rows[rowIndex].FindControl("txtExchangeRateFactor")).Text;
paymentExchangeRatesBL = new PaymentExchangeRatesBL();
DataSet updatedData = paymentExchangeRatesBL.UpdatePaymentExchangeRates(companyCode, currencyCode, Convert.ToInt32(monthId), Convert.ToDouble(exchangeRateFactor), userCode, out errorId);
paymentExchangeRatesBL = null;
if (updatedData.Tables.Count != 0 && errorId != 2)
{
Session["ExchangeRateFactorData"] = updatedData.Tables[0];
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
BindGrid(updatedData.Tables[0]);
hdnChangeNotSaved.Value = "N";
hdnGridRowSelectedPrvious.Value = null;
msgView.SetMessage("Payment exchange rate details saved successfully.", MessageType.Success, PositionType.Auto);
}
else
{
msgView.SetMessage("Failed to save payment exchange rate details.", MessageType.Warning, PositionType.Auto);
}
}
}
private void LoadData()
{
string primaryCompanyCode = string.Empty;
paymentExchangeRatesBL = new PaymentExchangeRatesBL();
DataSet initialData = paymentExchangeRatesBL.GetInitialData(out primaryCompanyCode, out errorId);
paymentExchangeRatesBL = null;
if (initialData.Tables.Count != 0 && errorId != 2)
{
hdnPageNumber.Value = "1";
if (initialData.Tables.Count > 1)
{
txtCompany.Text = primaryCompanyCode;
ddlCompany.Visible = false;
txtCompany.Visible = true;
rfddlCompany.Enabled = false;
if (initialData.Tables[1].Rows.Count > 0)
{
Session["ExchangeRateFactorData"] = initialData.Tables[1];
BindGrid(initialData.Tables[1]);
}
else
{
dtEmpty = new DataTable();
gvExchangeRateDetails.DataSource = dtEmpty;
gvExchangeRateDetails.DataBind();
}
}
else
{
ddlCompany.DataSource = initialData.Tables[0];
ddlCompany.DataTextField = "company_data";
ddlCompany.DataValueField = "company_code";
ddlCompany.DataBind();
ddlCompany.Items.Insert(0, new ListItem("-"));
ddlCompany.Visible = true;
rfddlCompany.Enabled = true;
txtCompany.Visible = false;
}
}
}
