public void LoadGrid()
{
try
{
SMHR_CURRENCY _obj_Currency = new SMHR_CURRENCY();
_obj_Currency.OPERATION = operation.Select;
_obj_Currency.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = BLL.get_Currency(_obj_Currency);
Rg_Currency.DataSource = DT;
clearControls();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Currency", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void LoadToCurrency()
{
try
{
rcmb_ToCurrency.Items.Clear();
_obj_smhr_Currency = new SMHR_CURRENCY();
_obj_smhr_Currency.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt_Details = BLL.get_Currency(_obj_smhr_Currency);
rcmb_ToCurrency.DataSource = dt_Details;
rcmb_ToCurrency.DataTextField = "CURR_CODE";
rcmb_ToCurrency.DataValueField = "CURR_ID";
rcmb_ToCurrency.DataBind();
rcmb_ToCurrency.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmCurrencyConversion", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
loadDropdown();
clearControls();
rtxt_CurrencyCode.Enabled = false;
_obj_Smhr_Currency = new SMHR_CURRENCY();
_obj_Smhr_Currency.OPERATION = operation.Select;
_obj_Smhr_Currency.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Currency.CURR_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
DataTable dt = BLL.get_Currency(_obj_Smhr_Currency);
lbl_CurrencyID.Text = Convert.ToString(dt.Rows[0]["CURR_ID"]);
rtxt_CurrencyCode.Text = Convert.ToString(dt.Rows[0]["CURR_CODE"]);
rtxt_CurrencyDesc.Text = Convert.ToString(dt.Rows[0]["CURR_DESCRIPTION"]);
rcmb_CurrencyCountry.SelectedIndex = rcmb_CurrencyCountry.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["CURR_COUNTRY_ID"]));
rtxt_CurrencySymbol.Text = Convert.ToString(dt.Rows[0]["CURR_SYMBOL"]);
rntxt_CurrencyPrecision.Text = Convert.ToString(dt.Rows[0]["CURR_PRECESION"]);
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
Rm_CU_page.SelectedIndex = 1;
rcmb_CurrencyCountry.Enabled = false;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Currency", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
_obj_Smhr_Currency = new SMHR_CURRENCY();
_obj_Smhr_Currency.CURR_CODE = BLL.ReplaceQuote(rtxt_CurrencyCode.Text.ToUpper());
_obj_Smhr_Currency.CURR_DESCRIPTION = BLL.ReplaceQuote(rtxt_CurrencyDesc.Text);
_obj_Smhr_Currency.CURR_COUNTRY_ID = Convert.ToInt32(rcmb_CurrencyCountry.SelectedItem.Value);
_obj_Smhr_Currency.CURR_SYMBOL = BLL.ReplaceQuote(rtxt_CurrencySymbol.Text);
_obj_Smhr_Currency.CURR_PRECESION = Convert.ToInt32(rntxt_CurrencyPrecision.Text);
_obj_Smhr_Currency.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Currency.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Currency.CREATEDDATE = DateTime.Now;
//_obj_Smhr_Currency.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Currency.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Currency.LASTMDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_Currency.OPERATION = operation.Update;
_obj_Smhr_Currency.CURR_ID = Convert.ToInt32(lbl_CurrencyID.Text);
if (BLL.set_Currency(_obj_Smhr_Currency))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_Currency.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_Currency(_obj_Smhr_Currency).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Currency with this Code Already Exists");
return;
}
_obj_Smhr_Currency.OPERATION = operation.Validate;
if (Convert.ToString(BLL.get_Currency(_obj_Smhr_Currency).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Currency for this Country Already Exists");
return;
}
_obj_Smhr_Currency.OPERATION = operation.Insert;
if (BLL.set_Currency(_obj_Smhr_Currency))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_CU_page.SelectedIndex = 0;
LoadGrid();
Rg_Currency.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Currency", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
