public static bool EditKeyword(ATTKeyword obj, Previlege pobj)
{
string EditSP;
EditSP = "SP_EDIT_KEYWORD";
OracleParameter[] paramArray = new OracleParameter[2];
paramArray[0] = Utilities.GetOraParam(":p_KEYWORD_ID", obj.KeywordID, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[1] = Utilities.GetOraParam(":p_KEYWORD_NAME", obj.KeywordName, 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 Keyword.");
}
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, EditSP, paramArray);
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
getConn.CloseDbConn();
}
}
public static bool EditKeyword(ATTKeyword obj, Previlege pobj)
{
try
{
return(DLLKeyword.EditKeyword(obj, pobj));
}
catch (Exception ex)
{
throw ex;
}
}
public static ObjectValidation Validate(ATTKeyword obj)
{
ObjectValidation OV = new ObjectValidation();
if (obj.KeywordName == "")
{
OV.IsValid = false;
OV.ErrorMessage = "Keyword name cannot be empty.";
return(OV);
}
return(OV);
}
protected void lstKeyword_SelectedIndexChanged(object sender, EventArgs e)
{
List <ATTKeyword> lst = (List <ATTKeyword>)Session["Keyword_KeywordList"];
ATTKeyword keyword = lst.Find
(
delegate(ATTKeyword key)
{
return(key.KeywordID == int.Parse(this.lstKeyword.SelectedValue));
}
);
this.txtKeywordName_Rqd.Text = keyword.KeywordName;
}
public static List <ATTKeyword> GetKeywordList(int?keywordID)
{
List <ATTKeyword> lstKeyword = new List <ATTKeyword>();
try
{
foreach (DataRow row in DLLKeyword.GetKeywordTable(keywordID).Rows)
{
ATTKeyword obj = new ATTKeyword
(
int.Parse(row["Keyword_ID"].ToString()),
row["Keyword_Name"].ToString()
);
lstKeyword.Add(obj);
}
return(lstKeyword);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddKeyword(ATTKeyword obj, Previlege pobj)
{
string InsertSP;
InsertSP = "SP_ADD_KEYWORD";
OracleParameter[] paramArray = new OracleParameter[3];
paramArray[0] = Utilities.GetOraParam(":p_KEYWORD_ID", obj.KeywordID, OracleDbType.Int64, ParameterDirection.InputOutput);
paramArray[1] = Utilities.GetOraParam(":p_KEYWORD_NAME", obj.KeywordName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":p_ENTRY_BY", obj.EntryBy, 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 + " add Author.");
}
SqlHelper.ExecuteNonQuery(DBConn, CommandType.StoredProcedure, InsertSP, paramArray);
obj.KeywordID = int.Parse(paramArray[0].Value.ToString());
return(true);
}
catch (Exception ex)
{
throw ex;
}
finally
{
getConn.CloseDbConn();
}
}
protected void btnAddKeyword_Click(object sender, EventArgs e)
{
if (this.ddlKeyword.SelectedIndex <= 0)
{
return;
}
ATTLibraryMaterial LM = (ATTLibraryMaterial)Session["LM_LibraryMaterial"];
GridViewRow row;
int rowCount = 0;
foreach (ATTLibraryMaterialKeyword ky in LM.LstLMKeyword)
{
row = this.grdKeyword.Rows[rowCount];
ky.HasChecked = ((CheckBox)row.FindControl("chkKeyword")).Checked;
rowCount = rowCount + 1;
}
ATTKeyword key = new ATTKeyword
(
int.Parse(this.ddlKeyword.SelectedValue),
this.ddlKeyword.SelectedItem.Text
);
ATTLibraryMaterialKeyword LMkey = new ATTLibraryMaterialKeyword();
LMkey.OrgID = int.Parse(this.ddlOrg.SelectedValue);
LMkey.LibraryID = int.Parse(this.ddlLibrary.SelectedValue);
if (this.hdnAction.Value != "M")
{
LMkey.LMaterialID = 0;
}
LMkey.EntryBy = ((ATTUserLogin)Session["Login_User_Detail"]).UserName;
LMkey.EntryOn = DateTime.Now;
LMkey.Action = "A";
LMkey.HasChecked = false;
LMkey.Keyword = key;
ATTLibraryMaterialKeyword existKey = LM.LstLMKeyword.Find
(
delegate(ATTLibraryMaterialKeyword lmk)
{
return
(lmk.OrgID == LMkey.OrgID &&
lmk.LibraryID == LMkey.LibraryID &&
lmk.KeywordID == LMkey.KeywordID);
}
);
if (existKey != null)
{
return;
}
LM.LstLMKeyword.Add(LMkey);
this.grdKeyword.DataSource = LM.LstLMKeyword;
this.grdKeyword.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ATTKeyword keywordObj = new ATTKeyword
(
0,
this.txtKeywordName_Rqd.Text,
((ATTUserLogin)Session["Login_User_Detail"]).UserName,
DateTime.Now
);
ObjectValidation OV = BLLKeyword.Validate(keywordObj);
if (OV.IsValid == false)
{
this.lblStatus.Text = OV.ErrorMessage;
return;
}
List <ATTKeyword> lstKey = (List <ATTKeyword>)Session["Keyword_KeywordList"];
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
try
{
if (this.lstKeyword.SelectedIndex < 0)
{
if (user.MenuList["4,5,1"] == null || user.MenuList["4,5,1"].PAdd == "N")
{
this.lblStatus.Text = Utilities.PreviledgeMsg + " add Keyword.";
return;
}
Previlege pobj = new Previlege(user.UserName, "4,5,1", int.Parse(((HiddenField)this.Master.FindControl("hdnApplicationID")).Value), Previlege.PrevilegeType.P_ADD);
BLLKeyword.AddKeyword(keywordObj, pobj);
lstKey.Add(keywordObj);
}
else
{
if (user.MenuList["4,5,1"] == null || user.MenuList[Session["List_Menuname"].ToString()].PEdit == "N")
{
this.lblStatus.Text = Utilities.PreviledgeMsg + " update Keyword.";
return;
}
Previlege pobj = new Previlege(user.UserName, "4,5,1", int.Parse(((HiddenField)this.Master.FindControl("hdnApplicationID")).Value), Previlege.PrevilegeType.P_EDIT);
BLLKeyword.EditKeyword(keywordObj, pobj);
lstKey[this.lstKeyword.SelectedIndex] = keywordObj;
}
this.lstKeyword.DataSource = lstKey;
this.lstKeyword.DataTextField = "KeywordName";
this.lstKeyword.DataValueField = "KeywordID";
this.lstKeyword.DataBind();
this.ClearKeywordControl();
}
catch (Exception ex)
{
this.lblStatus.Text = ex.Message;
}
}
