//Ctrl + F Find Column
public void FindColumn(Window frmParent)
{
PromptForm._frmParent = frmParent;
string tableName = "";
MessageBoxResult result = PromptForm.ShowCombobox("FindColumn", "Table Name", ref tableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string colName = "";
result = PromptForm.ShowText("FindColumn", "Column Name", ref colName);
if (result == MessageBoxResult.Cancel)
{
return;
}
DataSet ds = SQLDBUtil.GetAllTableColumns(tableName, colName);
DataTable dtData = SQLDBUtil.GetDataTableByDataSet(ds);
if (dtData == null)
{
return;
}
dtData.TableName = tableName;
ShowResultData(frmParent, dtData, "");
}
//Alt + 1 View Data by No
public void GetViewDataByNo(Window frmParent)
{
PromptForm._frmParent = frmParent;
string tableName = "";
MessageBoxResult result = PromptForm.ShowCombobox("ViewDataByNo", "Table Name", ref tableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string colName = "";
result = PromptForm.ShowText("ViewDataByNo", "Column Name", ref colName);
if (result == MessageBoxResult.Cancel)
{
return;
}
if (string.IsNullOrEmpty(colName))
{
colName = "*";
}
string strWhere = string.Empty;
if (SQLDBUtil.ColumnIsExistInTable(tableName, "AAStatus"))
{
strWhere = "AAStatus = 'Alive'";
}
string strQuery = SQLDBUtil.GenerateQuery(tableName, strWhere, colName);
//DataTable dtData = SQLDBUtil.GetDataByTable(tableName, strWhere, colName);
//if (dtData == null) return;
//dtData.TableName = tableName;
ShowResultData(frmParent, null, strQuery);
}
public void AddIndex()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTblName = "";
MessageBoxResult result = PromptForm.ShowCombobox(str, "Table Name", ref strTblName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strColName = "";
result = PromptForm.ShowText(str, "Column Name", ref strColName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strIdxName = "";
result = PromptForm.ShowText(str, "Index Name", ref strIdxName);
if (result == MessageBoxResult.Cancel)
{
return;
}
int iResult = SQLDBUtil.ExecuteNonQuery(string.Format("CREATE INDEX {0} ON {1}({2})", strIdxName, strTblName, strColName));
ShowMessenger(iResult);
}
public void ChangeDbLaravel(Window frmParent)
{
if (!CheckSelectedDB())
{
return;
}
string sourceUrl = GetSourceCodePath();
string filePath = Directory.GetFiles(sourceUrl, "*.env").FirstOrDefault();
string[] lines = File.ReadAllLines(filePath);
string[] lstDBs = SQLDBUtil.GetDataTableByDataSet(SQLDBUtil.GetAllDatabases()).Select().Select(x => x[0].ToString()).ToArray();
string DBVal = lines.ToList().Find(x => x.StartsWith("DB_DATABASE")).Split('=').LastOrDefault();
if (PromptForm.ShowCombobox("Change Database Name", "Database Name", lstDBs, ref DBVal) == MessageBoxResult.OK)
{
SQLAppWaitingDialog.ShowDialog();
int idx = lines.ToList().FindIndex(x => x.StartsWith("DB_DATABASE"));
lines[idx] = string.Format("{0}={1}", "DB_DATABASE", DBVal);
File.WriteAllLines(filePath, lines);
FunctionListObject functionObj = new FunctionListObject();
functionObj.FuncName = "CmdLaravelConfigCache";
ExecutedScriptCommand(functionObj, frmParent);
SQLAppWaitingDialog.HideDialog();
}
}
public void ShowFunctionList(string strFuncName, Window frmParent)
{
string sourceUrl = SQLApp.GetIniFile(strFileName, "SourceCode", "SourceUrl");
bool isReturn = false;
if (string.IsNullOrEmpty(sourceUrl) || !Directory.Exists(sourceUrl))
{
isReturn = true;
FolderBrowserDialog folder = new FolderBrowserDialog();
if (folder.ShowDialog() == DialogResult.OK)
{
SQLApp.SetIniFile(strFileName, "SourceCode", "SourceUrl", folder.SelectedPath);
isReturn = false;
}
}
if (isReturn)
{
return;
}
List <string> lstFuncs = SQLApp.GetKeysIniFile(strCfgScriptName, strFuncName, 3000);
List <FunctionListObject> lstObjectFuncs = new List <FunctionListObject>();
lstFuncs.ForEach(x =>
{
string caption = SQLApp.GetIniFile(strCfgScriptName, "Captions", x);
if (string.IsNullOrEmpty(caption))
{
caption = string.Join(" ", x.ToUpper().Split('_'));
}
lstObjectFuncs.Add(new FunctionListObject {
Name = x, Text = caption
});
});
PromptForm._frmParent = frmParent;
string value = string.Empty;
MessageBoxResult messageResult = PromptForm.ShowCombobox("Function List In Source", "Function Name", lstObjectFuncs.Select(x => x.Text).ToArray(), ref value);
if (messageResult == MessageBoxResult.OK)
{
FunctionListObject functionObj = lstObjectFuncs.Find(x => x.Text.Equals(value));
string strKey = (functionObj != null) ? functionObj.Name : string.Empty;
string functionName = SQLApp.GetIniFile(strCfgScriptName, strFuncName, strKey);
if (functionName.StartsWith("Cmd"))
{
functionObj.FuncName = functionName;
ExecutedScriptCommand(functionObj, frmParent);
}
else
{
CallMethodName(functionName, frmParent);
}
}
}
public void ShowChangeTheme()
{
string _themeName = ApplicationThemeHelper.ApplicationThemeName;
if (PromptForm.ShowCombobox("Change Theme", "Theme Name", Theme.Themes.Select(x => x.Name).ToArray(), ref _themeName) == MessageBoxResult.Cancel)
{
return;
}
SetThemeName(_themeName);
//System.Diagnostics.Process.Start(System.Windows.Forms.Application.ExecutablePath);
//Environment.Exit(Environment.ExitCode);
ApplicationThemeHelper.ApplicationThemeName = _themeName;
}
//Ctrl + Alt + T : Gen Script Create Table
public void GenScriptCreateTable(Window frmParent)
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTableName = "";
MessageBoxResult result = PromptForm.ShowCombobox(str, "Table Name", ref strTableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strQuery = SQLApp.GetFile(strPath + "GenCreateTable.sql");
strQuery = strQuery.Replace("@TableName@", strTableName);
DataTable dt = SQLDBUtil.GetDataTable(strQuery);
ShowResultData(frmParent, dt, strQuery);
}
//Ctrl + 6: Gen Info / Controller
public void GenInfoController()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTableName = "";
MessageBoxResult result = PromptForm.ShowCombobox(str, "Table Name", ref strTableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strType = string.Empty;
result = PromptForm.ShowCombobox(str, "Gen Controller", new string[] { "YES", "NO" }, ref strType);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strQuery = SQLApp.GetFile(strPath + "GenInfo.sql");
strQuery = strQuery.Replace("@TableName@", strTableName);
strQuery = strQuery.Replace("@Version@", System.Windows.Forms.Application.ProductName + " - " + System.Windows.Forms.Application.ProductVersion);
strQuery = strQuery.Replace("@CreatedDate@", DateTime.Now.ToShortDateString());
DataTable dt = SQLDBUtil.GetDataTable(strQuery);
if (dt != null)
{
string strContent = Convert.ToString(dt.Rows[0][0]);
SQLApp.WriteFile("D:\\" + strTableName + "Info.cs", strContent);
//NotifycationAler aler = new NotifycationAler();
//aler.ShowDialog();
}
if (strType == "YES")
{
strQuery = SQLApp.GetFile(strPath + "GenController.sql");
strQuery = strQuery.Replace("@TableName@", strTableName);
strQuery = strQuery.Replace("@Version@", System.Windows.Forms.Application.ProductName + " - " + System.Windows.Forms.Application.ProductVersion);
strQuery = strQuery.Replace("@CreatedDate@", DateTime.Now.ToShortDateString());
dt = SQLDBUtil.GetDataTable(strQuery);
if (dt != null)
{
string strContent = Convert.ToString(dt.Rows[0][0]);
SQLApp.WriteFile("D:\\" + strTableName + "Controller.cs", strContent);
}
}
}
public void ShowFunctionList()
{
GetFunctionList();
string[] lstSource = lstFuncLst.Keys.ToArray();
string value = "";
MessageBoxResult result = PromptForm.ShowCombobox("Action", "Action", lstSource, ref value);
if (result == MessageBoxResult.Cancel)
{
return;
}
//switch (value)
//{
EnterFunctionList lstThis = new EnterFunctionList();
MethodInfo mi = lstThis.GetType().GetMethod(lstFuncLst[value]);
mi.Invoke(lstThis, null);
//MethodInfo miConstructed = mi.MakeGenericMethod(type[0]);
//}
}
public void AddColumn()
{
string str = MethodInfo.GetCurrentMethod().Name;
string strTblName = "";
MessageBoxResult result = PromptForm.ShowCombobox(str, "Table Name", ref strTblName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string strColName = "";
result = PromptForm.ShowText(str, "Column Name", ref strColName);
if (result == MessageBoxResult.Cancel)
{
return;
}
int iResult = SQLDBUtil.ExecuteNonQuery(string.Format("ALTER TABLE {0} ADD {1}", strTblName, strColName));
ShowMessenger(iResult);
}
