public static ResultBOL <object> ExecuteScalar(string query, Hashtable hashTable) { string tag = _tag + "[ExcuteScalar]"; try { SqlConnection conn = new SqlConnection(ConnectionString()); SqlCommand cmd = CreateSqlCommandQuery(conn, query, hashTable); conn.Open(); object result = cmd.ExecuteScalar(); cmd.Dispose(); conn.Close(); return(new ResultBOL <object>() { Code = 0, Data = result }); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(new ResultBOL <object>() { Code = ex.HResult, ErrorMessage = ex.Message, Data = null }); } }
public static string GetErrorMessage(string key) { string tag = "[Utilities][GetErrorMessage]"; try { string path = HttpContext.Current.Server.MapPath("~/XML/ErrorMessage.xml"); DataSet ds = new DataSet(); ds.ReadXml(path); foreach (DataRow row in ds.Tables[0].Rows) { if (row["Key"].ToString() == key) { return(row["Value"].ToString()); } } return(string.Empty); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(ex.Message); } }
public static ResultBOL <DataSet> ExecuteQuery(string query, Hashtable hashTable) { string tag = _tag + "[ExecuteQuery]"; try { SqlConnection conn = new SqlConnection(ConnectionString()); SqlCommand cmd = CreateSqlCommandQuery(conn, query, hashTable); conn.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); cmd.Dispose(); conn.Close(); return(new ResultBOL <DataSet>() { Code = 0, Data = ds }); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(new ResultBOL <DataSet>() { Code = ex.HResult, ErrorMessage = ex.Message, Data = null }); } }
private static string SaveFileToServer(string url, string dir) { string tag = "[Utilities][SaveFileToServer]"; try { string ext = Path.GetExtension(url); string fileName = string.Format("{0}{1}", DateTime.Now.ToString("MMddyyyy-HHmmssfff"), ext); //--- string dirServer = HttpContext.Current.Server.MapPath(dir); if (!Directory.Exists(dirServer)) { Directory.CreateDirectory(dirServer); } string fullPath = Path.Combine(dirServer, fileName); WebClient wc = new WebClient(); wc.DownloadFile(new Uri(url), fullPath); return(Path.Combine(dir, fileName)); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(string.Empty); } }
public static string GetSortImageUrl(string key) { string tag = "[Utilities][GetSortImageUrl]"; try { string path = HttpContext.Current.Server.MapPath("~/XML/GridView.xml"); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(path); var node = xmlDoc.SelectSingleNode(string.Format("Resources/{0}", key)); if (node == null) { return(string.Empty); } return(node.InnerText); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(string.Empty); } }
public static RedirectUrlBOL GetRedirectUrlObject(string name) { string tag = "[Utilities][GetRedirectUrlObject]"; try { string path = HttpContext.Current.Server.MapPath("~/XML/MenuRedirectUrl.xml"); DataSet ds = new DataSet(); ds.ReadXml(path); foreach (DataRow row in ds.Tables[0].Rows) { if (row["Name"].ToString() == name) { return(new RedirectUrlBOL(row)); } } } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); } return(new RedirectUrlBOL() { Id = 0, Value = "~/Default.aspx" }); }
public static void SaveLoggedInfo(UserBOL user) { try { var session = HttpContext.Current.Session; session["LoggedId"] = user.Id; session["LoggedUsername"] = user.Username; } catch (Exception ex) { LogHelpers.WriteError("[Utilities][SaveLoggedInfo] Exception: " + ex.ToString()); } }
private static string ConnectionString() { string tag = _tag + "[ConnectionString]"; try { string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; return(connectionString); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(string.Empty); } }
public static string CreateMapPath(string dir, string file) { string tag = "[Utilities][CreateMapPath]"; try { string result = HttpContext.Current.Server.MapPath(Path.Combine(dir, file)); return(result); } catch (Exception ex) { LogHelpers.WriteError(string.Format("{0} - Directory: {1} - File: {2}", tag, dir, file), ex.ToString()); return(string.Empty); } }
public static ResultBOL <DataSet> ExecuteStoredReturnDataSet(string stored, Object obj) { string tag = _tag + "[ExecuteStoredReturnDataSet]"; try { SqlConnection conn = new SqlConnection(ConnectionString()); SqlCommand cmd = CreateSqlCommandStored(conn, stored, Utilities.GetParameters(obj)); SqlParameter dbReturn = cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int); dbReturn.Direction = ParameterDirection.ReturnValue; conn.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); cmd.Dispose(); conn.Close(); return(new ResultBOL <DataSet>() { Code = 0, DbReturnValue = (int)dbReturn.Value, Data = ds }); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(new ResultBOL <DataSet>() { Code = ex.HResult, ErrorMessage = ex.Message, Data = null }); } }
public static string ReplaceImageUri(string html, string imageDir) { string tag = "[Utilities][ReplaceImageUri]"; try { HtmlDocument htmlDoc = new HtmlDocument(); htmlDoc.OptionAutoCloseOnEnd = true; htmlDoc.LoadHtml(html); foreach (HtmlNode node in htmlDoc.DocumentNode.SelectNodes("//img[@src]")) { var src = node.Attributes["src"].Value.Split('?')[0]; if (!src.Contains("://")) { continue; } //var width = node.Attributes["width"].Value.Replace("px", ""); //var height = node.Attributes["height"].Value.Replace("px", ""); src = SaveFileToServer(src, imageDir); node.SetAttributeValue("src", src); //node.SetAttributeValue("src", string.Format( // "{0}?width={1}&height={2}", // src, // width == null ? "auto" : width, // height == null ? "auto" : height)); } return(htmlDoc.DocumentNode.OuterHtml); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(html); } }
private static SqlCommand CreateSqlCommandStored(SqlConnection conn, string stored, Hashtable hashTable) { string tag = _tag + "[CreateSqlCommandStored]"; try { SqlCommand cmd = new SqlCommand(stored, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = _commandTimeout; if (hashTable == null || hashTable.Count == 0) { return(cmd); } foreach (DictionaryEntry entry in hashTable) { if (entry.Key == null || string.IsNullOrEmpty(entry.Key.ToString())) { continue; } string key = "@" + entry.Key.ToString(); object value = entry.Value == null ? DBNull.Value : entry.Value; SqlParameter para = new SqlParameter(key, value); cmd.Parameters.Add(para); } return(cmd); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(null); } }
private void StartUpdateSiteVisitors() { string tag = __tag + "[StartUpdateSiteVisitors]"; LogHelpers.WriteStatus(tag, "Start..."); try { var result = SiteVisitorsDAL.UpdateSiteVisitors(); if (result.Code < 0) { LogHelpers.WriteError(tag, result.ErrorMessage); } } catch (Exception ex) { LogHelpers.WriteException(tag, ex.ToString()); } finally { LogHelpers.WriteStatus(tag, "End."); } }
private void StartGetMenuName(int _menuId) { string tag = __tag + "[StartGetMenuName]"; LogHelpers.WriteStatus(tag, "menuId: " + _menuId.ToString(), "Start..."); try { var result = MenuDAL.GetMenuName(_menuId); if (result.Code < 0) { LogHelpers.WriteError(tag, result.ErrorMessage); return; } lbContentHeader.InnerText = result.Data.ToString(); } catch (Exception ex) { LogHelpers.WriteException(tag, ex.Message); } }
public static string EncryptPassword(string input) { try { MD5 md5 = MD5.Create(); byte[] hashData = md5.ComputeHash(Encoding.Default.GetBytes(input)); StringBuilder result = new StringBuilder(); for (int i = 0; i < hashData.Length; i++) { result.Append(hashData[i].ToString("X2")); } return(result.ToString()); } catch (Exception ex) { LogHelpers.WriteError("[Utilities][EncryptPassword] Exception: " + ex.ToString()); return(string.Empty); } }
public static string SetFullLinkImage(string html, string rootImageDir) { string tag = "[Utilities][SetFullLinkImage]"; try { HtmlDocument htmlDoc = new HtmlDocument(); htmlDoc.OptionAutoCloseOnEnd = true; htmlDoc.LoadHtml(html); foreach (HtmlNode node in htmlDoc.DocumentNode.SelectNodes("//img[@src]")) { var src = node.Attributes["src"].Value.Split('?')[0]; if (src.Contains("://")) { continue; } string fullPath = Path.Combine(rootImageDir, src); node.SetAttributeValue("src", fullPath.Replace("\\", "/")); //node.SetAttributeValue("src", string.Format( // "{0}?width={1}&height={2}", // src, // width == null ? "auto" : width, // height == null ? "auto" : height)); } return(htmlDoc.DocumentNode.OuterHtml); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(html); } }
public static ResultBOL <int> ExecuteStored(string stored, Hashtable hashTable) { string tag = _tag + "[ExecuteStored]"; try { SqlConnection conn = new SqlConnection(ConnectionString()); SqlCommand cmd = CreateSqlCommandStored(conn, stored, hashTable); SqlParameter dbReturn = cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int); dbReturn.Direction = ParameterDirection.ReturnValue; conn.Open(); cmd.ExecuteNonQuery(); cmd.Dispose(); conn.Close(); return(new ResultBOL <int>() { Code = (int)dbReturn.Value, DbReturnValue = (int)dbReturn.Value }); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); return(new ResultBOL <int>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }