/// <summary>
/// Connects to database and returns search procedure name by search procedure ID.
/// </summary>
/// <param name="SageFrameSearchProcedureID">Search procedure ID.</param>
/// <returns>Search procedure.</returns>
public SageFrameSearchProcedureInfo SageFrameSearchProcedureGet(string SageFrameSearchProcedureID)
{
try
{
List <KeyValuePair <string, object> > ParaMeterCollection = new List <KeyValuePair <string, object> >();
ParaMeterCollection.Add(new KeyValuePair <string, object>("@SageFrameSearchProcedureID", SageFrameSearchProcedureID));
SQLHandler sagesql = new SQLHandler();
SageFrameSearchProcedureInfo objSpIno = sagesql.ExecuteAsObject <SageFrameSearchProcedureInfo>("dbo.sp_SageFrameSearchProcedureGet", ParaMeterCollection);
return(objSpIno);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Connects to database and adds or updates SageFrame search
/// </summary>
/// <param name="objInfo">Object of SageFrameSearchProcedureInfo class.</param>
/// <param name="PortalID">Portal ID.</param>
/// <param name="AddedBy">Search added user's name.</param>
public void SageFrameSearchProcedureAddUpdate(SageFrameSearchProcedureInfo objInfo, int PortalID, string AddedBy)
{
try
{
List <KeyValuePair <string, string> > ParaMeterCollection = new List <KeyValuePair <string, string> >();
ParaMeterCollection.Add(new KeyValuePair <string, string>("@SageFrameSearchProcedureID", objInfo.SageFrameSearchProcedureID.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@SageFrameSearchTitle", objInfo.SageFrameSearchTitle));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@SageFrameSearchProcedureName", objInfo.SageFrameSearchProcedureName.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@SageFrameSearchProcedureExecuteAs", objInfo.SageFrameSearchProcedureExecuteAs));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@IsActive", objInfo.IsActive.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@AddedOn", objInfo.AddedOn.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@PortalID", PortalID.ToString()));
ParaMeterCollection.Add(new KeyValuePair <string, string>("@AddedBy", AddedBy));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("dbo.sp_SageFrameSearchProcedureAddUpdate", ParaMeterCollection);
}
catch (Exception e)
{
throw e;
}
}
private void SaveExtension()
{
try
{
int SageFrameSearchProcedureID = 0;
if (Session["EditID"] != null)
{
//Update
SageFrameSearchProcedureID = Int32.Parse(Session["EditID"].ToString());
}
SageFrameSearchProcedureInfo objInfo = new SageFrameSearchProcedureInfo();
objInfo.AddedBy = GetUsername;
objInfo.AddedOn = DateTime.Now;
objInfo.DeletedBy = GetUsername;
objInfo.DeletedOn = DateTime.Now;
objInfo.IsActive = true;
objInfo.IsDeleted = false;
objInfo.IsModified = false;
objInfo.PortalID = GetPortalID;
objInfo.SageFrameSearchProcedureExecuteAs = txtSageFrameSearchProcedureExecuteAs.Text.Trim();
objInfo.SageFrameSearchProcedureID = SageFrameSearchProcedureID;
objInfo.SageFrameSearchProcedureName = txtSageFrameSearchProcedureName.Text.Trim();
objInfo.SageFrameSearchTitle = txtSageFrameSearchTitle.Text.Trim();
objInfo.UpdatedBy = GetUsername;
objInfo.UpdatedOn = DateTime.Now;
SageFrameSearch SFH = new SageFrameSearch();
SFH.SageFrameSearchProcedureAddUpdate(objInfo, GetPortalID, GetUsername);
ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("SageFrameSearch", "SearchExtensionSavedSuccessfully"), "", SageMessageType.Success);
ClearForm();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public void SageFrameSearchProcedureAddUpdate(SageFrameSearchProcedureInfo objInfo, int PortalID, string AddedBy)
{
try
{
List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>();
ParaMeterCollection.Add(new KeyValuePair<string, string>("@SageFrameSearchProcedureID", objInfo.SageFrameSearchProcedureID.ToString()));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@SageFrameSearchTitle", objInfo.SageFrameSearchTitle));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@SageFrameSearchProcedureName", objInfo.SageFrameSearchProcedureName.ToString()));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@SageFrameSearchProcedureExecuteAs", objInfo.SageFrameSearchProcedureExecuteAs));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@IsActive", objInfo.IsActive.ToString()));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@AddedOn", objInfo.AddedOn.ToString()));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID.ToString()));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@AddedBy", AddedBy));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("dbo.sp_SageFrameSearchProcedureAddUpdate", ParaMeterCollection);
}
catch (Exception e)
{
throw e;
}
}