public static void Addparamater(ref Hashtable hshParamater, string strKey, string strValue)
{
try
{
if (!hshParamater.ContainsKey(strKey) && hshParamater != null && !String.IsNullOrEmpty(strKey) && !String.IsNullOrEmpty(strValue))
{
hshParamater.Add(strKey, "N'" + strValue.Replace("'", "''") + "'");
}
}
catch (Exception ex)
{
Hashtable hshParam = new Hashtable();
hshParam.Add("Error", ex.Message);
hshParam.Add("Key", strKey);
hshParam.Add("Value", strValue);
hshParam.Add("UID", Gadget.GetUserID());
Expose178.Com.UtilityFactory.Log.WriteLog(hshParam, "GadgetScripts.Addparamater()", UtilityFactory.LogType.LogToFile);
}
}
public static int?GetNullableIntValue(DataRow dr, string strColumn)
{
int?intReturn = null;
if (dr != null)
{
try
{
if (dr[strColumn] != DBNull.Value)
{
intReturn = Convert.ToInt32(dr[strColumn]);
}
}
catch (Exception ex)
{
Hashtable hshParam = new Hashtable();
hshParam.Add("UID", Gadget.GetUserID());
hshParam.Add("Error", ex.Message);
Expose178.Com.UtilityFactory.Log.WriteLog(hshParam, "Gadget.GetNullableIntValue()", UtilityFactory.LogType.LogToDB);
}
}
return(intReturn);
}
public static DateTime GetDataRowDateTimeValue(DataRow dr, string strColumn)
{
DateTime dt = DateTime.Now;
if (dr != null)
{
try
{
if (dr[strColumn] != DBNull.Value)
{
dt = Convert.ToDateTime(dr[strColumn]);
}
}
catch (Exception ex)
{
Hashtable hshParam = new Hashtable();
hshParam.Add("UID", Gadget.GetUserID());
hshParam.Add("Error", ex.Message);
Expose178.Com.UtilityFactory.Log.WriteLog(hshParam, "Gadget.GetDataRowDateTimeValue()", UtilityFactory.LogType.LogToDB);
}
}
return(dt);
}
public static bool GetDataRowBoolValue(DataRow dr, string strColumn)
{
bool bReturn = false;
if (dr != null)
{
try
{
if (dr[strColumn] != DBNull.Value)
{
bReturn = Convert.ToBoolean(dr[strColumn]);
}
}
catch (Exception ex)
{
Hashtable hshParam = new Hashtable();
hshParam.Add("UID", Gadget.GetUserID());
hshParam.Add("Error", ex.Message);
Expose178.Com.UtilityFactory.Log.WriteLog(hshParam, "Gadget.GetDataRowBoolValue()", UtilityFactory.LogType.LogToDB);
}
}
return(bReturn);
}
public static string GetDataRowStringValue(DataRow dr, string strColumn)
{
string strReturnValue = null;
try
{
if (dr != null)
{
if (dr[strColumn] != DBNull.Value)
{
strReturnValue = dr[strColumn].ToString();
}
}
}
catch (Exception ex)
{
Hashtable hshParam = new Hashtable();
hshParam.Add("UID", Gadget.GetUserID());
hshParam.Add("Error", ex.Message);
Expose178.Com.UtilityFactory.Log.WriteLog(hshParam, "Gadget.GetDataRowStringValue()", UtilityFactory.LogType.LogToDB);
}
return(strReturnValue);
}
