/// <summary>
/// This methods check in database if tag exist, then returns tag Nid
/// else add tag to database and return Nid of Newly created tag
/// </summary>
/// <param name="Tag">Input Tag name</param>
/// <returns>Tag NId</returns>
public int CreateAndGetTagNid(string Tag)
{
CMSHelper ObjCMSHelper = new CMSHelper();
string ResultNid = string.Empty;
int RetVal = 0;
string DBConnectionStatusMessage = string.Empty;
List<System.Data.Common.DbParameter> DbParams = null;
DIConnection ObjDIConnection = null;
int MaxTagId = -1;
try
{
// Call method to get connection object
ObjDIConnection = ObjCMSHelper.GetConnectionObject(out DBConnectionStatusMessage);
// Check if connection object is not null
if (ObjDIConnection == null)
{
RetVal = -1;
return RetVal;
}
// Innitilze DbParams object
DbParams = new List<System.Data.Common.DbParameter>();
// create tag parameter
System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();
Param1.ParameterName = "@Tags";
Param1.DbType = DbType.String;
Param1.Value = Tag;
DbParams.Add(Param1);
// Execute stored procedure to get tag Nid
MaxTagId = Convert.ToInt32(ObjDIConnection.ExecuteScalarSqlQuery("sp_CreateAndGetTagNid", CommandType.StoredProcedure, DbParams));
if (MaxTagId > 0)
{
RetVal = MaxTagId;
}
}
catch (Exception Ex)
{
RetVal = -1;
Global.CreateExceptionString(Ex, null);
}
finally
{
DbParams = null;
ObjDIConnection = null;
}
return RetVal;
}
public bool DeleteTagsMappingsByTagId(int Tag)
{
CMSHelper ObjCMSHelper = new CMSHelper();
string ResultNid = string.Empty;
bool RetVal = false;
List<System.Data.Common.DbParameter> DbParams = null;
DIConnection ObjDIConnection = null;
int RetDelTagId = -1;
try
{
// Call method to get connection object
ObjDIConnection = ObjCMSHelper.GetConnectionObject();
// Check if connection object is not null
if (ObjDIConnection == null)
{
RetVal = false;
return RetVal;
}
// Innitilze DbParams object
DbParams = new List<System.Data.Common.DbParameter>();
// create tag parameter
System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();
Param1.ParameterName = "@TagId";
Param1.DbType = DbType.Int32;
Param1.Value = Tag;
DbParams.Add(Param1);
// Execute stored procedure to get tag Nid
RetDelTagId = Convert.ToInt32(ObjDIConnection.ExecuteScalarSqlQuery("sp_DeleteTagsMappingsByTagId", CommandType.StoredProcedure, DbParams));
if (RetDelTagId > 0)
{
RetVal = true;
}
}
catch (Exception Ex)
{
RetVal = false;
Global.CreateExceptionString(Ex, null);
}
finally
{
DbParams = null;
ObjDIConnection = null;
}
return RetVal;
}
public bool AddMenuCategory(string CategoryName, string LinkText, string HeaderText, string HeaderDesc,string PageName)
{
DIConnection ObjDIConnection = null;
CMSHelper Helper = new CMSHelper();
List<System.Data.Common.DbParameter> DbParams = null;
bool RetVal = false;
int AddMenuCategory = -1;
try
{ //Get Connection Object
ObjDIConnection = Helper.GetConnectionObject();
// Checke if Connection object is null then return null and stop further flow to execute
if (ObjDIConnection == null)
{ return RetVal; }
// If Connection object is not null then excute further code
else
{
DbParams = new List<System.Data.Common.DbParameter>();
// create database parameters
System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param1.ParameterName = "@MenuCategory";
Param1.DbType = DbType.String;
Param1.Value = CategoryName;
DbParams.Add(Param1);
System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param2.ParameterName = "@LinkText";
Param2.DbType = DbType.String;
Param2.Value = LinkText;
DbParams.Add(Param2);
System.Data.Common.DbParameter Param3 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param3.ParameterName = "@HeaderText";
Param3.DbType = DbType.String;
Param3.Value = HeaderText;
DbParams.Add(Param3);
System.Data.Common.DbParameter Param4 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param4.ParameterName = "@HeaderDesc";
Param4.DbType = DbType.String;
Param4.Value = HeaderDesc;
DbParams.Add(Param4);
System.Data.Common.DbParameter Param5 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param5.ParameterName = "@IsVisible";
Param5.DbType = DbType.String;
Param5.Value = true;
DbParams.Add(Param5);
System.Data.Common.DbParameter Param6 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param6.ParameterName = "@PageName";
Param6.DbType = DbType.String;
Param6.Value = PageName;
DbParams.Add(Param6);
// Execute stored procedure to add menu category from database
AddMenuCategory = Convert.ToInt32(ObjDIConnection.ExecuteNonQuery("sp_AddMenuCategory", CommandType.StoredProcedure, DbParams));
// Check if return datatable is not null and having atleast 1 record
if (AddMenuCategory > 0)
{
RetVal = true;
}
}
}
catch (Exception Ex)
{
RetVal = false;
Global.CreateExceptionString(Ex, null);
}
finally
{
ObjDIConnection = null;
}
return RetVal;
}
public bool MoveUpNDownMenuCat(string MenuCategory, bool MoveUp, bool MoveDown,string PageName)
{
bool RetVal = false;
DIConnection ObjDIConnection = null;
CMSHelper Helper = new CMSHelper();
List<System.Data.Common.DbParameter> DbParams = null;
int MenuCateMoved = -1;
try
{ //Get Connection Object
ObjDIConnection = Helper.GetConnectionObject();
// Checke if Connection object is null then return null and stop further flow to execute
if (ObjDIConnection == null)
{ return RetVal; }
// If Connection object is not null then excute further code
else
{
DbParams = new List<System.Data.Common.DbParameter>();
// create database parameters
System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param1.ParameterName = "@MenuCategory";
Param1.DbType = DbType.String;
Param1.Value = MenuCategory;
DbParams.Add(Param1);
// create database parameters
System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param2.ParameterName = "@MoveUp";
Param2.DbType = DbType.Int16;
Param2.Value = MoveUp;
DbParams.Add(Param2);
// create database parameters
System.Data.Common.DbParameter Param3 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param3.ParameterName = "@MoveDown";
Param3.DbType = DbType.Int16;
Param3.Value = MoveDown;
DbParams.Add(Param3);
System.Data.Common.DbParameter Param4 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param4.ParameterName = "@PageName";
Param4.DbType = DbType.String;
Param4.Value = PageName;
DbParams.Add(Param4);
// Execute stored procedure to delete menu category from database
MenuCateMoved = Convert.ToInt32(ObjDIConnection.ExecuteScalarSqlQuery("sp_MoveUpNDownMenuCat", CommandType.StoredProcedure, DbParams));
if (MenuCateMoved >= 0)
{
RetVal = true;
}
}
}
catch (Exception Ex)
{
RetVal = false;
Global.CreateExceptionString(Ex, null);
}
finally
{
ObjDIConnection = null;
}
return RetVal;
}
public string GetMenuCategoriesListJson(bool IsCategoryVisible,string PageName)
{
System.Web.Script.Serialization.JavaScriptSerializer jSearializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List<MenuCategories> RetMenuCat = null;
string RetVal = string.Empty;
DIConnection ObjDIConnection = null;
CMSHelper Helper = new CMSHelper();
List<System.Data.Common.DbParameter> DbParams = null;
DataTable DtRetData = null;
try
{ //Get Connection Object
ObjDIConnection = Helper.GetConnectionObject();
// Checke if Connection object is null then return null and stop further flow to execute
if (ObjDIConnection == null)
{ return RetVal; }
// If Connection object is not null then excute further code
else
{
DbParams = new List<System.Data.Common.DbParameter>();
// create database parameters
System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param1.ParameterName = "@IsVisible";
Param1.DbType = DbType.Int32;
Param1.Value = IsCategoryVisible;
DbParams.Add(Param1);
System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param2.ParameterName = "@PageName";
Param2.DbType = DbType.String;
Param2.Value = PageName;
DbParams.Add(Param2);
// Execute stored procedure to get Tags From Database
DtRetData = ObjDIConnection.ExecuteDataTable("sp_GetMenuCategoriesByPageName", CommandType.StoredProcedure, DbParams);
// Check if return datatable is not null and having atleast 1 record
if (DtRetData != null && DtRetData.Rows.Count > 0)
{
RetMenuCat = new List<MenuCategories>();
// Itterate through loop
for (int Icount = 0; Icount < DtRetData.Rows.Count; Icount++)
{
MenuCategories ObjMenuCat = new MenuCategories();
ObjMenuCat.MenuCategory = DtRetData.Rows[Icount]["MenuCategory"].ToString();
ObjMenuCat.LinkText = DtRetData.Rows[Icount]["LinkText"].ToString();
ObjMenuCat.HeaderText = DtRetData.Rows[Icount]["HeaderText"].ToString();
ObjMenuCat.HeaderDesc = DtRetData.Rows[Icount]["HeaderDesc"].ToString();
ObjMenuCat.PageName = DtRetData.Rows[Icount]["PageName"].ToString();
// assign tag value to list RetVal
RetMenuCat.Add(ObjMenuCat);
}
}
RetVal = jSearializer.Serialize(RetMenuCat);
}
}
catch (Exception Ex)
{
RetVal = string.Empty;
Global.CreateExceptionString(Ex, null);
}
finally
{
ObjDIConnection = null;
}
return RetVal;
}
public bool DeleteMenuCategory(string CategoryName)
{
bool RetVal = false;
DIConnection ObjDIConnection = null;
CMSHelper Helper = new CMSHelper();
List<System.Data.Common.DbParameter> DbParams = null;
int DeleteMenuCate = -1;
try
{ //Get Connection Object
ObjDIConnection = Helper.GetConnectionObject();
// Checke if Connection object is null then return null and stop further flow to execute
if (ObjDIConnection == null)
{ return RetVal; }
// If Connection object is not null then excute further code
else
{
DbParams = new List<System.Data.Common.DbParameter>();
// create database parameters
System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();// create RecordStartPosition parameter
Param1.ParameterName = "@MenuCategory";
Param1.DbType = DbType.String;
Param1.Value = CategoryName;
DbParams.Add(Param1);
// Execute stored procedure to delete menu category from database
DeleteMenuCate = Convert.ToInt32(ObjDIConnection.ExecuteScalarSqlQuery("sp_DeleteMenuCategory", CommandType.StoredProcedure, DbParams));
if (DeleteMenuCate >= 0)
{
RetVal = true;
}
}
}
catch (Exception Ex)
{
RetVal = false;
Global.CreateExceptionString(Ex, null);
}
finally
{
ObjDIConnection = null;
}
return RetVal;
}
// Create new content page andd add link on main html page
private bool AddCMSContentToDB(DataContent CMSDataContent)
{
bool RetVal = false;
string ConnectionMessage = string.Empty;
List<System.Data.Common.DbParameter> DbParams = new List<System.Data.Common.DbParameter>();
DIConnection ObjDIConnection = null;
int DtAddCmsCont = -1;
try
{
CMSHelper ObjCMSHelper = new CMSHelper();
// call method to get connection object
ObjDIConnection = ObjCMSHelper.GetConnectionObject(out ConnectionMessage);
// create database parameters
System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();
Param1.ParameterName = "@MenuCategory";
Param1.DbType = DbType.String;
Param1.Value = CMSDataContent.MenuCategory;
DbParams.Add(Param1);
System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter();
Param2.ParameterName = "@Title";
Param2.DbType = DbType.String;
Param2.Value = CMSDataContent.Title;
DbParams.Add(Param2);
System.Data.Common.DbParameter Param3 = ObjDIConnection.CreateDBParameter();
Param3.ParameterName = "@Date";
Param3.DbType = DbType.DateTime;
Param3.Value = CMSDataContent.Date;
DbParams.Add(Param3);
System.Data.Common.DbParameter Param4 = ObjDIConnection.CreateDBParameter();
Param4.ParameterName = "@Thumbnail";
Param4.DbType = DbType.String;
Param4.Value = CMSDataContent.Thumbnail;
DbParams.Add(Param4);
System.Data.Common.DbParameter Param5 = ObjDIConnection.CreateDBParameter();
Param5.ParameterName = "@Summary";
Param5.DbType = DbType.String;
Param5.Value = CMSDataContent.Summary;
DbParams.Add(Param5);
System.Data.Common.DbParameter Param6 = ObjDIConnection.CreateDBParameter();
Param6.ParameterName = "@Description";
Param6.DbType = DbType.String;
Param6.Value = CMSDataContent.Description;
DbParams.Add(Param6);
System.Data.Common.DbParameter Param7 = ObjDIConnection.CreateDBParameter();
Param7.ParameterName = "@PDFUpload";
Param7.DbType = DbType.String;
Param7.Value = CMSDataContent.PDFUpload;
DbParams.Add(Param7);
System.Data.Common.DbParameter Param8 = ObjDIConnection.CreateDBParameter();
Param8.ParameterName = "@DateAdded";
Param8.DbType = DbType.DateTime;
Param8.Value = CMSDataContent.DateAdded;
DbParams.Add(Param8);
System.Data.Common.DbParameter Param9 = ObjDIConnection.CreateDBParameter();
Param9.ParameterName = "@DateModified";
Param9.DbType = DbType.DateTime;
Param9.Value = CMSDataContent.DateModified;
DbParams.Add(Param9);
System.Data.Common.DbParameter Param10 = ObjDIConnection.CreateDBParameter();
Param10.ParameterName = "@Archived";
Param10.DbType = DbType.Boolean;
Param10.Value = CMSDataContent.Archived;
DbParams.Add(Param10);
System.Data.Common.DbParameter Param11 = ObjDIConnection.CreateDBParameter();
Param11.ParameterName = "@ArticleTagId";
Param11.DbType = DbType.Int32;
Param11.Value = CMSDataContent.ArticleTagID;
DbParams.Add(Param11);
System.Data.Common.DbParameter Param12 = ObjDIConnection.CreateDBParameter();
Param12.ParameterName = "@UserNameEmail";
Param12.DbType = DbType.String;
Param12.Value = CMSDataContent.UserNameEmail;
DbParams.Add(Param12);
System.Data.Common.DbParameter Param14 = ObjDIConnection.CreateDBParameter();
Param14.ParameterName = "@URL";
Param14.DbType = DbType.String;
Param14.Value = CMSDataContent.URL;
DbParams.Add(Param14);
System.Data.Common.DbParameter Param15 = ObjDIConnection.CreateDBParameter();
Param15.ParameterName = "@LngCode";
Param15.DbType = DbType.String;
Param15.Value = CMSDataContent.LngCode;
DbParams.Add(Param15);
System.Data.Common.DbParameter Param16 = ObjDIConnection.CreateDBParameter();
Param16.ParameterName = "@IsDeleted";
Param16.DbType = DbType.Boolean;
Param16.Value =CMSDataContent.IsDeleted;
DbParams.Add(Param16);
System.Data.Common.DbParameter Param17 = ObjDIConnection.CreateDBParameter();
Param17.ParameterName = "@IsHidden";
Param17.DbType = DbType.Boolean;
Param17.Value = CMSDataContent.IsHidden;
DbParams.Add(Param17);
System.Data.Common.DbParameter Param18 = ObjDIConnection.CreateDBParameter();
Param18.ParameterName = "@Fld1";
Param18.DbType = DbType.String;
Param18.Value = "";
DbParams.Add(Param18);
System.Data.Common.DbParameter Param19 = ObjDIConnection.CreateDBParameter();
Param19.ParameterName = "@Fld2";
Param19.DbType = DbType.String;
Param19.Value = "";
DbParams.Add(Param19);
System.Data.Common.DbParameter Param20 = ObjDIConnection.CreateDBParameter();
Param20.ParameterName = "@Fld3";
Param20.DbType = DbType.String;
Param20.Value = "";
DbParams.Add(Param20);
System.Data.Common.DbParameter Param21 = ObjDIConnection.CreateDBParameter();
Param21.ParameterName = "@Fld4";
Param21.DbType = DbType.String;
Param21.Value = "";
DbParams.Add(Param21);
System.Data.Common.DbParameter Param22 = ObjDIConnection.CreateDBParameter();
Param22.ParameterName = "@Fld5";
Param22.DbType = DbType.String;
Param22.Value = "";
DbParams.Add(Param22);
System.Data.Common.DbParameter Param23 = ObjDIConnection.CreateDBParameter();
Param23.ParameterName = "@Fld6";
Param23.DbType = DbType.String;
Param23.Value = "";
DbParams.Add(Param23);
System.Data.Common.DbParameter Param24 = ObjDIConnection.CreateDBParameter();
Param24.ParameterName = "@Fld1Text";
Param24.DbType = DbType.String;
Param24.Value = "";
DbParams.Add(Param24);
System.Data.Common.DbParameter Param25 = ObjDIConnection.CreateDBParameter();
Param25.ParameterName = "@Fld2Text";
Param25.DbType = DbType.String;
Param25.Value = "";
DbParams.Add(Param25);
System.Data.Common.DbParameter Param26 = ObjDIConnection.CreateDBParameter();
Param26.ParameterName = "@Fld3Text";
Param26.DbType = DbType.String;
Param26.Value = "";
DbParams.Add(Param26);
System.Data.Common.DbParameter Param27= ObjDIConnection.CreateDBParameter();
Param27.ParameterName = "@Fld4Text";
Param27.DbType = DbType.String;
Param27.Value = "";
DbParams.Add(Param27);
System.Data.Common.DbParameter Param28 = ObjDIConnection.CreateDBParameter();
Param28.ParameterName = "@Fld5Text";
Param28.DbType = DbType.String;
Param28.Value = "";
DbParams.Add(Param28);
System.Data.Common.DbParameter Param29 = ObjDIConnection.CreateDBParameter();
Param29.ParameterName = "@Fld6Text";
Param29.DbType = DbType.String;
Param29.Value = "";
DbParams.Add(Param29);
// Execute stored procedure to Insert CMS Content In Database
DtAddCmsCont = ObjDIConnection.ExecuteNonQuery("sp_AddCMSContent", CommandType.StoredProcedure, DbParams);
//To check if records inserted in database,check if count of no of rows effected is greater than 0
if (DtAddCmsCont > 0)
{
RetVal = true;
}
// return false
else
{
RetVal = false;
}
}
catch (Exception Ex)
{
RetVal = false;
Global.CreateExceptionString(Ex, null);
}
return RetVal;
}
/// Create CMS database for adaptation If Database Not exise
/// </summary>
/// <param name="CMSDatabaseName">Name of the created Cms Database</param>
/// <returns>True if database created or already exist</returns>
public bool MigratorHtmlContentToDb(List<DataContent> InputListDataContent, out string ContentDbImportMessage)
{
bool RetVal = false;
DIConnection ObjDIConnection = null;
CMSHelper ObjCmsHelper = new CMSHelper();
string DbScripts = string.Empty;
string LngDbScripts = string.Empty;
string ConnectionMessage = string.Empty;
string QryStr = string.Empty;
DataTable DTCounts;
List<System.Data.Common.DbParameter> DbParams = new List<System.Data.Common.DbParameter>();
try
{
ObjDIConnection = ObjCmsHelper.GetConnectionObject(out ConnectionMessage);
if (ObjDIConnection == null)
{
ContentDbImportMessage = ConnectionMessage;
RetVal = false;
return RetVal;
}
else
{
foreach (DataContent DContent in InputListDataContent)
{
try
{
if (!string.IsNullOrEmpty(DContent.Title) || !string.IsNullOrEmpty(DContent.Summary.ToString()) || !string.IsNullOrEmpty(DContent.Thumbnail.ToString())
|| !string.IsNullOrEmpty(DContent.Description.ToString()) || !string.IsNullOrEmpty(DContent.PDFUpload.ToString()))
{
QryStr = "select * from DataContent where Title='" + DContent.Title.Replace("'", "''") + "'" + "and Date='" + DContent.Date + "' and Summary='" + DContent.Summary.Replace("'", "''") + "'";
DTCounts = ObjDIConnection.ExecuteDataTable(QryStr);
if (DTCounts.Rows.Count == 0)
{
QryStr = "INSERT into DataContent (MenuCategory, Title, Date, Thumbnail, Summary, Description, PDFUpload, DateAdded,DateModified, Archived, ArticleTagId, UserNameEmail, URL, LngCode, IsDeleted,IsHidden) Values (" + "'" + DContent.MenuCategory + "','" + DContent.Title.Replace("'", "''") + "','" + DContent.Date + "','" + DContent.Thumbnail + "','" + DContent.Summary.Replace("'", "''") + "','" + DContent.Description.Replace("'", "''") + "','" + DContent.PDFUpload + "','" + DContent.DateAdded + "','" + DContent.DateModified + "','" + DContent.Archived + "','" + DContent.ArticleTagID + "','" + DContent.UserNameEmail.Replace("'", "''") + "','" + DContent.URL + "','" + DContent.LngCode + "','" + DContent.IsDeleted + "','" + DContent.IsHidden + "')";
ObjDIConnection.ExecuteNonQuery(QryStr);
}
}
}
catch (Exception Ex)
{
string ExceptionMgs = "Exception occured in method ImportHtmlContentToDb while insering records in database,";
ExceptionMgs = " Exception message is" + Ex.InnerException.ToString() + "Stack trace is" + Ex.StackTrace.ToString();
Global.WriteErrorsInLogFolder(ExceptionMgs);
ContentDbImportMessage = "Error occured while importing datavalues to database";
RetVal = false;
}
}
}
// Set Retval to true
RetVal = true;
// Dispose connection object
ObjDIConnection.Dispose();
}
catch (Exception ex)
{
ContentDbImportMessage = "Error occured while importing datavalues to database";
RetVal = false;
Global.CreateExceptionString(ex, null);
}
finally
{ // dispose connection object
ObjDIConnection = null;
}
ContentDbImportMessage = string.Empty;
return RetVal;
}
public bool ShowHideArticlebyContentId(int ContentId, bool IsHidden)
{
CMSHelper ObjCMSHelper = new CMSHelper();
string ResultNid = string.Empty;
bool RetVal = false;
List<System.Data.Common.DbParameter> DbParams = null;
DIConnection ObjDIConnection = null;
int RetDelTagId = -1;
try
{
// Call method to get connection object
ObjDIConnection = ObjCMSHelper.GetConnectionObject();
// Check if connection object is not null
if (ObjDIConnection == null)
{
RetVal = false;
return RetVal;
}
// Innitilze DbParams object
DbParams = new List<System.Data.Common.DbParameter>();
System.Data.Common.DbParameter Param1 = ObjDIConnection.CreateDBParameter();
Param1.ParameterName = "@ContentId";
Param1.DbType = DbType.Int32;
Param1.Value = ContentId;
DbParams.Add(Param1);
System.Data.Common.DbParameter Param2 = ObjDIConnection.CreateDBParameter();
Param2.ParameterName = "@IsHidden";
Param2.DbType = DbType.Boolean;
Param2.Value = IsHidden;
DbParams.Add(Param2);
// Execute stored procedure to get tag Nid
RetDelTagId = Convert.ToInt32(ObjDIConnection.ExecuteNonQuery("sp_ShowHideArticlesByContentId", CommandType.StoredProcedure, DbParams));
if (RetDelTagId > 0)
{
RetVal = true;
}
}
catch (Exception Ex)
{
RetVal = false;
Global.CreateExceptionString(Ex, null);
}
finally
{
DbParams = null;
ObjDIConnection = null;
}
return RetVal;
}
