using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using TSqlFormatter;
using TSqlFormatter.Formatters;

namespace DevelopAssistant.Format
{
 public class TsqlFormatHelper
 {
 public static string FormatToTSQL(string strsql, bool caseWrite)
 {
 string result = string.Empty;

 if (string.IsNullOrEmpty(strsql))
 return strsql;

 try
 {
 //bool errorsEncountered = false;
 //result = SqlFormattingManager.DefaultFormat(strsql, ref errorsEncountered);

 bool errorsEncountered = false;
 SqlFormattingManager formaterManager = new SqlFormattingManager();
 TSqlStandardFormatter formater = (TSqlStandardFormatter)formaterManager.Formatter;
 formater.Options.UppercaseKeywords = caseWrite;
 result = formaterManager.Format(strsql, ref errorsEncountered);

 }
 catch (Exception ex)
 {
 result = strsql;
 }

 return result;
 }

 public static string FormatToString(string strsql,bool caseWrite)
 {
 return FormatToTSQL(strsql, caseWrite);
 }

 public static string CompressToString(string strsql)
 {
 string result = string.Empty;

 strsql = strsql.Replace("//", "");
 strsql = strsql.Replace('\r', ' ');
 strsql = strsql.Replace('\n', ' ');
 //strsql = Regex.Replace(strsql, " +", " ", RegexOptions.None); 

 char[] char_array = strsql.ToCharArray();
 List<char> char_list = new List<char>();

 int space_count = 0;
 for (int i = 0, len = char_array.Length; i < len; i++)
 {
 char chr = char_array[i];
 if (chr == ' ')
 {
 space_count++;
 if (space_count == 1)
 {
 char_list.Add(chr);
 }
 }
 if (chr != ' ')
 {
 space_count = 0;
 char_list.Add(chr);
 }

 }

 result =string.Concat(char_list.ToArray());

 return result;
 }

 }
}