protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlCompany.SelectedIndex > 0)
{
txtExchangeRateFactor.Enabled = true;
txtTransactionReceiptDate.Enabled = true;
imgBtnInsert.Enabled = true;
exchangeRateFactorsBL = new ExchangeRateFactorsBL();
DataSet companyData = exchangeRateFactorsBL.GetCompanyData(ddlCompany.SelectedValue, out errorId);
exchangeRateFactorsBL = null;
if (companyData.Tables.Count != 0 && errorId != 2)
{
Session["ExchangeRateFactorData"] = companyData.Tables[1];
gvExchangeRateDetails.PageIndex = 0;
//WUIN-746 clearing sort hidden files
hdnSortExpression.Value = string.Empty;
hdnSortDirection.Value = string.Empty;
BindGrid(companyData.Tables[1]);
ddlCompany.Items.FindByValue(companyData.Tables[0].Rows[0]["company_code"].ToString()).Selected = true;
txtDomesticCurrency.Text = companyData.Tables[0].Rows[0]["currency_code"].ToString();
txtDomesticCurrencyGrouping.Text = companyData.Tables[0].Rows[0]["domestic_currency_group"].ToString();
}
else
{
ExceptionHandler("Error in fetching data", string.Empty);
}
}
else
{
txtDomesticCurrency.Text = string.Empty;
txtDomesticCurrencyGrouping.Text = string.Empty;
txtExchangeRateFactor.Enabled = false;
txtTransactionReceiptDate.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 InsertExchangeRateFactor()
{
//Validate
Page.Validate("valInsertExchangeRates");
if (!Page.IsValid)
{
mpeSaveUndo.Hide();
msgView.SetMessage("Exchange rate factor details not saved – invalid or missing data!", MessageType.Warning, PositionType.Auto);
return;
}
string userCode = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
int month = Convert.ToInt32(txtTransactionReceiptDate.Text.Split('/')[0].ToString());
int year = Convert.ToInt32(txtTransactionReceiptDate.Text.Split('/')[1].ToString());
exchangeRateFactorsBL = new ExchangeRateFactorsBL();
DataSet updatedData = exchangeRateFactorsBL.InsertExchangeRateFactor(ddlCompany.SelectedValue, month, year, Convert.ToDouble(txtExchangeRateFactor.Text), userCode, out errorId);
exchangeRateFactorsBL = null;
if (errorId == 3)
{
msgView.SetMessage("Invalid month. Failed to save exchange rate factor details.", MessageType.Warning, PositionType.Auto);
}
else if (errorId == 1)
{
msgView.SetMessage("Exchange rate factor exists for this month and company.", 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";
txtTransactionReceiptDate.Text = string.Empty;
txtExchangeRateFactor.Text = string.Empty;
gvExchangeRateDetails.PageIndex = 0;
msgView.SetMessage("Exchange rate factor created successfully.", MessageType.Success, PositionType.Auto);
}
else
{
msgView.SetMessage("Failed to save exchange rate factor details.", MessageType.Warning, PositionType.Auto);
}
}
private void UpdateExchangeRateFactor()
{
if (!string.IsNullOrEmpty(hdnGridRowSelectedPrvious.Value))
{
string userCode = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString());
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("Exchange rate factor 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 monthId = ((HiddenField)gvExchangeRateDetails.Rows[rowIndex].FindControl("hdnMonthId")).Value;
string exchangeRateFactor = ((TextBox)gvExchangeRateDetails.Rows[rowIndex].FindControl("txtExchangeRateFactor")).Text;
exchangeRateFactorsBL = new ExchangeRateFactorsBL();
DataSet updatedData = exchangeRateFactorsBL.UpdateExchangeRateFactor(companyCode, Convert.ToInt32(monthId), Convert.ToDouble(exchangeRateFactor), userCode, out errorId);
exchangeRateFactorsBL = 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("Exchange rate factor details saved successfully.", MessageType.Success, PositionType.Auto);
}
else
{
msgView.SetMessage("Failed to save exchange rate factor details.", MessageType.Warning, PositionType.Auto);
}
}
}
private void LoadData()
{
exchangeRateFactorsBL = new ExchangeRateFactorsBL();
DataSet initialData = exchangeRateFactorsBL.GetInitialData(out errorId);
exchangeRateFactorsBL = null;
if (initialData.Tables.Count != 0 && errorId != 2)
{
hdnPageNumber.Value = "1";
ddlCompany.DataSource = initialData.Tables[0];
ddlCompany.DataTextField = "company_data";
ddlCompany.DataValueField = "company_code";
ddlCompany.DataBind();
ddlCompany.Items.Insert(0, new ListItem("-"));
if (initialData.Tables.Count > 1)
{
Session["ExchangeRateFactorData"] = initialData.Tables[2];
BindGrid(initialData.Tables[2]);
ddlCompany.Items.FindByValue(initialData.Tables[1].Rows[0]["company_code"].ToString()).Selected = true;
txtDomesticCurrency.Text = initialData.Tables[1].Rows[0]["currency_code"].ToString();
txtDomesticCurrencyGrouping.Text = initialData.Tables[1].Rows[0]["domestic_currency_group"].ToString();
txtCompany.Text = ddlCompany.SelectedItem.ToString();
ddlCompany.Visible = false;
txtCompany.Visible = true;
}
else
{
txtExchangeRateFactor.Enabled = false;
txtTransactionReceiptDate.Enabled = false;
imgBtnInsert.Enabled = false;
ddlCompany.Visible = true;
txtCompany.Visible = false;
}
}
else
{
ExceptionHandler("Error in fetching data", string.Empty);
}
}
