public static bool EditCurrency(ATTCurrency obj, Previlege pobj)
{
string EditSP;
EditSP = "SP_EDIT_CURRENCY";
OracleParameter[] paramArray = new OracleParameter[2];
paramArray[0] = Utilities.GetOraParam(":p_CURRENCY_ID", obj.CurrencyID, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[1] = Utilities.GetOraParam(":p_CURRENCY_NAME", obj.CurrencyName, OracleDbType.Varchar2, ParameterDirection.Input);
GetConnection getConn = new GetConnection();
try
{
OracleConnection DBConn = getConn.GetDbConn(Module.LIS);
if (Previlege.HasPrevilege(pobj, DBConn) == false)
{
throw new ArgumentException(Utilities.PreviledgeMsg + " update Currency.");
}
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, EditSP, paramArray);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
getConn.CloseDbConn();
}
}
//public static bool AddAuthor(ATTAuthor obj, Previlege pobj)
//{
// try
// {
// return DLLAuthor.AddAuthor(obj, pobj);
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
//public static bool EditCurrency(ATTCurrency obj, string username, string menuname)
public static bool EditCurrency(ATTCurrency obj, Previlege pobj)
{
try
{
return(DLLCurrency.EditCurrency(obj, pobj));
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTCurrency obj)
{
ObjectValidation OV = new ObjectValidation();
if (obj.CurrencyName == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Currency name cannot be empty.";
return(OV);
}
return(OV);
}
protected void lstCurrency_SelectedIndexChanged(object sender, EventArgs e)
{
List <ATTCurrency> lst = (List <ATTCurrency>)Session["Currency_CurrencyList"];
ATTCurrency currency = lst.Find
(
delegate(ATTCurrency cu)
{
return(cu.CurrencyID == int.Parse(this.lstCurrency.SelectedValue));
}
);
this.txtCurrencyName_Rqd.Text = currency.CurrencyName;
}
public static List <ATTCurrency> GetCurrencyList(int?currencyID)
{
List <ATTCurrency> lstCurrency = new List <ATTCurrency>();
try
{
foreach (DataRow row in DLLCurrency.GetCurrencyTable(currencyID).Rows)
{
ATTCurrency obj = new ATTCurrency
(
int.Parse(row["Currency_ID"].ToString()),
row["Currency_Name"].ToString()
);
lstCurrency.Add(obj);
}
return(lstCurrency);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ATTCurrency currencyObj = new ATTCurrency
(
0,
this.txtCurrencyName_Rqd.Text,
((ATTUserLogin)Session["Login_User_Detail"]).UserName,
DateTime.Now
);
ObjectValidation OV = BLLCurrency.Validate(currencyObj);
if (OV.IsValid == false)
{
this.lblStatus.Text = OV.ErrorMessage;
return;
}
List <ATTCurrency> lstCurr = (List <ATTCurrency>)Session["Currency_CurrencyList"];
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
try
{
if (this.lstCurrency.SelectedIndex < 0)
{
if (user.MenuList["4,6,1"] == null || user.MenuList["4,6,1"].PAdd == "N")
{
this.lblStatus.Text = Utilities.PreviledgeMsg + " add Currency.";
return;
}
Previlege pobj = new Previlege(user.UserName, "4,6,1", int.Parse(((HiddenField)this.Master.FindControl("hdnApplicationID")).Value), Previlege.PrevilegeType.P_ADD);
BLLCurrency.AddCurrency(currencyObj, pobj);
lstCurr.Add(currencyObj);
}
else
{
if (user.MenuList["4,6,1"] == null || user.MenuList["4,6,1"].PEdit == "N")
{
this.lblStatus.Text = Utilities.PreviledgeMsg + " update Currency.";
return;
}
Previlege pobj = new Previlege(user.UserName, "4,6,1", int.Parse(((HiddenField)this.Master.FindControl("hdnApplicationID")).Value), Previlege.PrevilegeType.P_EDIT);
currencyObj.CurrencyID = int.Parse(this.lstCurrency.SelectedValue);
BLLCurrency.EditCurrency(currencyObj, pobj);
lstCurr[this.lstCurrency.SelectedIndex] = currencyObj;
}
this.lstCurrency.DataSource = lstCurr;
this.lstCurrency.DataTextField = "CurrencyName";
this.lstCurrency.DataValueField = "CurrencyID";
this.lstCurrency.DataBind();
this.ClearCurrencyControl();
}
catch (Exception ex)
{
this.lblStatus.Text = ex.Message;
}
}