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