//void GetAutoSQLName_SolutionsDB(string TableName)
//{
// try
// {
// DataRowView myRow = (DataRowView)this.SolutionsDB_bindingSource.Current;
// if (myRow != null && myRow["SPFormat"].ToString().Length > 0)
// {
// this.txtSqlName_Insert.Text = myRow["SPFormat"].ToString().Replace("{TableName}", TableName).Replace("{Action}", "Insert");
// this.txtSqlName_Delete.Text = myRow["SPFormat"].ToString().Replace("{TableName}", TableName).Replace("{Action}", "Delete");
// this.txtSqlName_GetRecord.Text = myRow["SPFormat"].ToString().Replace("{TableName}", TableName).Replace("{Action}", "GetList");
// this.txtSqlName_Update.Text = myRow["SPFormat"].ToString().Replace("{TableName}", TableName).Replace("{Action}", "Update");
// }
// }
// catch (Exception ex)
// {
// CommonClasses.Messages.GeneralError(ex.Message, " Format");
// }
//}
void GetSelectDB_Tables()
{
try
{
DataTable myDataTable_SolutionsDBTables = new SolutionsDBTablesDAL().getList_Search(10000, 1, " SolutionsDBID= " + this.cmbSolutionsDB.SelectedValue.ToString(), "TableName");
if (myDataTable_SolutionsDBTables != null)
{
this.SolutionsDBTables_bindingSource.DataSource = myDataTable_SolutionsDBTables;
}
if (this.SolutionsDBTables_bindingSource.DataSource != null)
{
this.cmbDBTables.DataSource = this.SolutionsDBTables_bindingSource;
this.cmbDBTables.DisplayMember = "TableName";
this.cmbDBTables.ValueMember = "ID";
}
this.cmbDBTables.Refresh();
this.cmbDBTables.Update();
this.GetSelectDB_TableColumns();
}
catch (Exception ex)
{
}
}
//void GetAutoSQLName_SolutionsDB(string TableName)
//{
// try
// {
// DataRowView myRow = (DataRowView)this.SolutionsDB_bindingSource.Current;
// if (myRow != null && myRow["SPFormat"].ToString().Length > 0)
// {
// this.txtSqlName_Insert.Text = myRow["SPFormat"].ToString().Replace("{TableName}", TableName).Replace("{Action}", "Insert");
// this.txtSqlName_Delete.Text = myRow["SPFormat"].ToString().Replace("{TableName}", TableName).Replace("{Action}", "Delete");
// this.txtSqlName_GetRecord.Text = myRow["SPFormat"].ToString().Replace("{TableName}", TableName).Replace("{Action}", "GetList");
// this.txtSqlName_Update.Text = myRow["SPFormat"].ToString().Replace("{TableName}", TableName).Replace("{Action}", "Update");
// }
// }
// catch (Exception ex)
// {
// CommonClasses.Messages.GeneralError(ex.Message, " Format");
// }
//}
void GetSelectDB_Tables()
{
try
{
//DataTable myDataTable_SolutionsDBTables = new SolutionsDBTablesDAL().getList_Search(10000, 1, " SolutionsDBID= " + this.cmbSolutionsDB.SelectedValue.ToString(), "TableName");
DataTable myDataTable_SolutionsDBTables = new SolutionsDBTablesDAL().getUnMappedTables(int.Parse(this.cmbSolutions.SelectedValue.ToString()), int.Parse(this.cmbSolutionsDB.SelectedValue.ToString()));
if (myDataTable_SolutionsDBTables != null)
{
this.SolutionsDBTables_bindingSource.DataSource = myDataTable_SolutionsDBTables;
}
if (this.SolutionsDBTables_bindingSource.DataSource != null)
{
this.dvgUnMappedTables.DataSource = this.SolutionsDBTables_bindingSource;
this.dvgUnMappedTables.Columns["clmName"].DataPropertyName = "TableName";
}
this.dvgUnMappedTables.Refresh();
this.dvgUnMappedTables.Update();
}
catch (Exception ex)
{
}
}
void MySQL_Connect_GetTable()
{
try
{
DataRowView myRow = (DataRowView)this.SolutionsDB_bindingSource.Current;
SolutionsDBTablesDAL SolutionsDBTablesDAL = new SolutionsDBTablesDAL();
SolutionsDBTablesDAL.SolutionsDBID = this.CurrentDBID;
SolutionsDBTablesDAL.isActive = true;
SolutionsDBTablesDAL.UserId = Security.UserID;
if (myRow != null && myRow["DBType"].ToString().ToLower() == "my sql")
{
mySql_DB_Tables = new DataTable();
this.mySqlDBFunctions.Server = myRow["ServerName"].ToString();
this.mySqlDBFunctions.DatabaseName = myRow["DBName"].ToString();
this.mySqlDBFunctions.DBUserName = myRow["UserName"].ToString();
this.mySqlDBFunctions.DBPassword = myRow["DPassword"].ToString();
if (this.mySqlDBFunctions.getConnection().State == ConnectionState.Open)
{
mySql_DB_Tables = this.mySqlDBFunctions.getTablesList();
if (mySql_DB_Tables != null && mySql_DB_Tables.Rows.Count > 0)
{
foreach (DataRow myTableRow in mySql_DB_Tables.Rows)
{
SolutionsDBTablesDAL.TableName = myTableRow["Tables"].ToString();
SolutionsDBTablesDAL.Insert();
}
}
}
else
{
CommonClasses.Messages.GeneralError("Invalid server information.", " My DB SQL Connection");
}
}
else
{
CommonClasses.Messages.GeneralError("Selected DB is not My Sql DB.", " My DB SQL Connection");
}
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " My DB SQL Connection");
}
}
