public string GetValueFromColumn(string tableName, string columnName, string where) { var resultStr = string.Empty; try { var whereCnd = ConvertionHelper.GetWhere(where); var sql = string.Format(@"SELECT {1} FROM {0} {2}", tableName, columnName, whereCnd); var tbl = GetTable(sql); if (tbl.Rows.Count <= 0) { return(resultStr); } resultStr = tbl.Rows[0][columnName].ToString(); } catch (Exception ex) { SLLog.WriteError(new LogData { Source = ToString(), FunctionName = "GetValueFromColumn Error!", Ex = ex, }); if (Settings.ThrowExceptions) { throw new Exception("GetValueFromColumn Error!", ex); } } return(resultStr); }
public DataTable GetTable(string tableName, string where = null, string orderBy = null) { var currentSql = string.Empty; var dt = new DataTable(tableName); try { var whereCond = ConvertionHelper.GetWhere(where); var orderCond = ConvertionHelper.GetOrderBy(orderBy); var sql = currentSql = string.Format(@"SELECT * FROM {0} {1} {2}", tableName, whereCond, orderCond); dt = GetTable(sql); } catch (Exception ex) { SLLog.WriteError(new LogData { Source = ToString(), FunctionName = "GetTable Error!", AdditionalMessage = $"SQL: {currentSql}", Ex = ex, }); if (Settings.ThrowExceptions) { throw new Exception("GetTable Error!", ex); } } return(dt); }
public bool DeleteRows(string tableName, string where) { try { var whereCnd = ConvertionHelper.GetWhere(where); var result = m_Execute.ExecuteNonQuery(string.Format(@"DELETE FROM {0} {1}", tableName, whereCnd)); if (result == -2) { return(false); } return(true); } catch (Exception ex) { SLLog.WriteError(new LogData { Source = ToString(), FunctionName = "DeleteRows Error!", Ex = ex, }); if (Settings.ThrowExceptions) { throw new Exception("DeleteRows Error!", ex); } return(false); } }
public DataRow GetRow(string tableName, string where = null, string orderBy = null) { try { var whereCond = ConvertionHelper.GetWhere(where); var orderCnd = ConvertionHelper.GetOrderBy(orderBy); var sql = string.Format(@"SELECT * FROM {0} {1} {2}", tableName, whereCond, orderCnd); return(GetRow(sql)); } catch (Exception ex) { SLLog.WriteError(new LogData { Source = ToString(), FunctionName = "GetRow Error!", Ex = ex, }); if (Settings.ThrowExceptions) { throw new Exception("GetRow Error!", ex); } return(null); } }
public bool UpdateOneValue(string tableName, string column, string value, string where, string additionalMessage = "") { try { var whereCnd = ConvertionHelper.GetWhere(where); var sql = string.Format(@"UPDATE {0} SET {1} = '{2}', {3} = '{4}' {5}", tableName, column, ConvertionHelper.CleanStringForSQL(value), DbCIC.ModifyOn, DateTime.Now.ToString(), whereCnd); var result = m_Execute.ExecuteNonQuery(sql); if (result == -2) { return(false); } return(true); } catch (Exception ex) { SLLog.WriteError(new LogData { Source = ToString(), FunctionName = "UpdateOneValue Error!", AdditionalMessage = additionalMessage, Ex = ex, }); if (Settings.ThrowExceptions) { throw new Exception("UpdateOneValue Error!", ex); } return(false); } }
static void Main(string[] args) { if (ValidationHelper.Validate(args[0], args[1])) { Console.WriteLine(ConvertionHelper.ConvertNumberFrom10NotationToAnyOtherNotation(UInt32.Parse(args[0]), UInt32.Parse(args[1]))); } }
public string GetLastSortOrder(string tableName, string sortOrderColName, string where = null) { var result = "0"; try { var whereCnd = ConvertionHelper.GetWhere(where); var sql = string.Format(@"SELECT {0} FROM {1} {2} ORDER BY CAST({0} AS INTEGER) DESC", sortOrderColName, tableName, whereCnd); var tbl = GetTable(sql); if (tbl.Rows.Count <= 0) { return(result); } result = string.IsNullOrEmpty(tbl.Rows[0][sortOrderColName].ToString()) ? "0" : tbl.Rows[0][sortOrderColName].ToString(); SLLog.WriteInfo("GetLastSortOrder", "Getting last sort order successfully! => " + result, true); } catch (Exception ex) { SLLog.WriteError(new LogData { Source = ToString(), FunctionName = "GetLastSortOrder Error!", Ex = ex, }); if (Settings.ThrowExceptions) { throw new Exception("GetLastSortOrder Error!", ex); } } return(result); }
public static string ToHtmlTable(this DataTable pOdt, string pColumnName, string pQueryStringColumnName, string pUrl, string pToolTip, string pCssClassName) { string htmlResult = string.Empty; int i = 0; string css = string.Empty; if (!String.IsNullOrEmpty(pCssClassName)) { css = string.Format("class='{0}'", pCssClassName); } string fullDataClmnName = pToolTip.Contains("UseAsColumnName") ? pToolTip.Replace("UseAsColumnName", string.Empty) : string.Empty; foreach (DataRow row in pOdt.Rows) { string bgColor = ConvertionHelper.GetHtmlTableBgColor(i++); string encryptedData = EngineContext.Current.Resolve <ICoreCryptography>().Encrypt(row[pQueryStringColumnName].ToString()); string queryString = string.Format("?{0}={1}", pQueryStringColumnName, encryptedData); string fullUrl = pUrl + queryString; string data = row[pColumnName].ToString(); string toolTip = !String.IsNullOrEmpty(fullDataClmnName) ? row[fullDataClmnName].ToString() : pToolTip; htmlResult += string.Format("<tr><td {0}><a {4} title='{3}' href='{1}'>{2}</a></td></tr>", bgColor, fullUrl, data, toolTip, css); } htmlResult = string.Format(ConvertionHelper.TableTag, htmlResult); ConvertionHelper.SetHtmlTableBgColorsToDefault(); return(htmlResult); }
public static DataTable ToDataColumn(this string pValue, string pColumnName, char pSeparater) { if (pSeparater != ',') { pValue = pValue.Replace(pSeparater, ','); } return(ConvertionHelper.CommaSeparatedValueToDataColumn(pValue, pColumnName)); }
public static List <T> ToListArray <T>(this string pValue, char pSeparater) { if (pSeparater != ',') { pValue = pValue.Replace(pSeparater, ','); } return(ConvertionHelper.CommaSeparatedValueToListArray <T>(pValue)); }
public ImportVM(List <Translation> translations, List <Language.Languages> languages, ResourceManager rm, CultureInfo ci) { this.rm = rm; this.ci = ci; languagesOrder = languages; Translations = ConvertionHelper.ConvertTo(translations, languages); TranslationModel = translations; }
protected internal static Dictionary <string, string> CreateCoupon(Currency currency, decimal amount) { return(new Dictionary <string, string> { { "method", "CreateCoupon" }, { "currency", ConvertionHelper.EnumToString(currency) }, { "amount", ConvertionHelper.DecimalToString(amount) } }); }
public List <sp_manpower_status_summary_Oncall_per_total_requirementResult> ManpowerStatusSummaryOncallPerTotalRequirement() { var list = new List <sp_manpower_status_summary_Oncall_per_total_requirementResult>(); if (datefrom != null && dateto != null) { list = db.sp_manpower_status_summary_Oncall_per_total_requirement(ConvertionHelper.NulltoEmptyString(accountmanager), ConvertionHelper.NulltoEmptyString(BranchId), datefrom, dateto).ToList(); } return(list); }
public List <sp_manpower_status_summaryResult> ManpowerStatusSummary() { var list = new List <sp_manpower_status_summaryResult>(); if (datefrom != null && dateto != null) { list = db.sp_manpower_status_summary(ConvertionHelper.NulltoEmptyString(accountmanager), ConvertionHelper.NulltoEmptyString(BranchId), datefrom, dateto).ToList(); } return(list); }
private void ExecuteImport() { OpenFileDialog ofd = new OpenFileDialog(); if (ofd.ShowDialog() == true) { TranslationModel = GetWordsFromImport(ofd.FileName, Import.Unformatted); ClearTranslations(); Translations = ConvertionHelper.ConvertTo(TranslationModel, languagesOrder); } }
public Orbit(float x, float y, float radius, Orbit parent) { X = x; Y = y; Radius = radius; Parent = parent; angle = (float)(-Math.PI / 2f); int actualLevel = getActualLevel(); speed = ConvertionHelper.DegreesToRadians((float)Math.Pow(k, actualLevel - 1) / 10f); }
// TODO refactor rm and ci public ModifyWordVM(List <Translation> translations, EncodingVM encodingVM, List <Language.Languages> languages, ResourceManager rm, CultureInfo ci) { EncodingVM = encodingVM; Translations = ConvertionHelper.ConvertTo(translations, languages); UILanguage1 = languages[0].ToDescription(); UILanguage2 = languages[1].ToDescription(); TranslationsModel = translations; this.rm = rm; this.ci = ci; }
protected internal static Dictionary <string, string> Trade(Pair pair, TradeType type, decimal rate, decimal amount) { return(new Dictionary <string, string>() { { "method", "Trade" }, { "pair", ConvertionHelper.EnumToString(pair) }, { "type", ConvertionHelper.EnumToString(type) }, { "rate", ConvertionHelper.DecimalToString(rate) }, { "amount", ConvertionHelper.DecimalToString(amount) } }); }
private void ExecuteFormattedImport() { OpenFileDialog ofd = new OpenFileDialog(); List <Translation> translations; if (ofd.ShowDialog() == true) { string content = File.ReadAllText(ofd.FileName); translations = JsonConvert.DeserializeObject <List <Translation> >(content); Translations = ConvertionHelper.ConvertTo(translations, languagesOrder); } }
/// <summary> /// DataTable olarak gönderilen bir verinin istenen kolonunu Html tablo olarak geri döndürür /// </summary> public static string ToHtmlTable(this DataTable pOdt, string pColumnName) { string htmlResult = string.Empty; int i = 0; foreach (DataRow row in pOdt.Rows) { string bgColor = ConvertionHelper.GetHtmlTableBgColor(i++); htmlResult += string.Format("<tr><td {1}>{0}</td></tr>", row[pColumnName], bgColor); } htmlResult = string.Format(ConvertionHelper.TableTag, htmlResult); ConvertionHelper.SetHtmlTableBgColorsToDefault(); return(htmlResult); }
public void FromString_ConvertToTradeInfoType(string convertableString, bool valueExists) { bool parsedSuccessfully; TradeInfoType currency = ConvertionHelper.FromString <TradeInfoType>(convertableString, out parsedSuccessfully); if (!valueExists) { Assert.IsFalse(parsedSuccessfully); Assert.AreEqual(TradeInfoType.unknown, currency); } else { Assert.IsTrue(parsedSuccessfully); } }
public void FromString_ConvertToCurrency(string convertableString, bool valueExists) { bool parsedSuccessfully; Currency currency = ConvertionHelper.FromString <Currency>(convertableString, out parsedSuccessfully); if (!valueExists) { Assert.IsFalse(parsedSuccessfully); Assert.AreEqual(Currency.unknown, currency); } else { Assert.IsTrue(parsedSuccessfully); } }
/// <summary> /// Virgüllerle ayrışmıi bir string değeri Html tablo olarak geri döndürür /// </summary> public static string ToHtmlTable(this string pValue) { string htmlResult = string.Empty; int i = 0; string[] parca = pValue.Split(','); foreach (string item in parca) { string bgColor = ConvertionHelper.GetHtmlTableBgColor(i++); htmlResult += string.Format("<tr><td {1}>{0}</td></tr>", item, bgColor); } htmlResult = string.Format(ConvertionHelper.TableTag, htmlResult); ConvertionHelper.SetHtmlTableBgColorsToDefault(); return(htmlResult); }
public static int DescendingOrder(int inputNumber) { int output; // it was not explained in the task how to handle negative values so only choice I had was to throw an exception if (inputNumber < MinimalAllowedNumber) { throw new Exception($"Input number must be higher than or equal to { MinimalAllowedNumber }."); } var inputNumberAsCharArray = ConvertionHelper.IntToCharArray(inputNumber); SortingHelper.SortCharArrayDescending(inputNumberAsCharArray); output = ConvertionHelper.CharArrayToInt(inputNumberAsCharArray); return(output); }
private HttpWebRequest ConfigureRequest(byte[] data, Uri uri) { HttpWebRequest request = WebRequest.Create(uri) as HttpWebRequest; if (request == null) { throw new HttpException("Non HTTP WebRequest"); } request.Method = "POST"; request.Timeout = 10000; request.ContentType = "application/x-www-form-urlencoded"; request.ContentLength = data.Length; request.Headers.Add("Key", _key); request.Headers.Add("Sign", ConvertionHelper.ByteArrayToString(_hashMaker.ComputeHash(data)).ToLower()); return(request); }
public static string ToHtmlTable(this DataTable pOdt, string pColumnName, string pUrlColumnName, string pToolTip, string pCssClassName) { string htmlResult = string.Empty; int i = 0; string css = string.Empty; if (!String.IsNullOrEmpty(pCssClassName)) { css = string.Format("class='{0}'", pCssClassName); } foreach (DataRow row in pOdt.Rows) { string bgColor = ConvertionHelper.GetHtmlTableBgColor(i++); string adi = row[pColumnName].ToString(); string link = row[pUrlColumnName].ToString(); htmlResult += string.Format("<tr><td {0}><a {4} title='{3}' href='{1}'>{2}</a></td></tr>", bgColor, link, adi, pToolTip, css); } htmlResult = string.Format(ConvertionHelper.TableTag, htmlResult); ConvertionHelper.SetHtmlTableBgColorsToDefault(); return(htmlResult); }
/// <summary> /// Returns all information about the enum including; Name, Value and Detail. /// </summary> /// <typeparam name="T">Type of the enum.</typeparam> /// <returns></returns> public static List <Enumeration> GetEnumerations <T>() { List <Enumeration> enumerationList = new List <Enumeration>(); foreach (FieldInfo field in typeof(T).GetFields(BindingFlags.Static | BindingFlags.GetField | BindingFlags.Public)) { foreach (Attribute attrib in field.GetCustomAttributes(true)) { Enumeration enumeration = new Enumeration(); enumeration.Name = field.GetValue(null).ToString(); Type underlyingType = Enum.GetUnderlyingType(typeof(T)); enumeration.Value = ConvertionHelper.GetConvertedValue((Enum.Parse(typeof(T), field.GetValue(null).ToString())), underlyingType).ToString(); Detail detail = (Detail)attrib; enumeration.Detail = detail.Value; enumerationList.Add(enumeration); } } return(enumerationList); }
public DataTable GetTable(string tableName, string where = null, string orderBy = null) { var dt = new DataTable(tableName); try { var whereCond = ConvertionHelper.GetWhere(where); var orderCond = ConvertionHelper.GetOrderBy(orderBy); var sql = string.Format(@"SELECT * FROM {0} {1} {2}", tableName, whereCond, orderCond); dt = GetTable(sql); } catch (Exception ex) { SLLog.WriteError(new LogData { Source = ToString(), FunctionName = "GetTable Error!", Ex = ex, }); } return(dt); }
protected float degrees(float radians) { return(ConvertionHelper.RadiansToDegrees(radians)); }
protected float radians(float degrees) { return(ConvertionHelper.DegreesToRadians(degrees)); }