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); }