void AssignDBTable()
{
try
{
SolutionFolders_TablesDAL SolutionFolders_TablesDAL = new SolutionFolders_TablesDAL();
DataRowView myRows;
SolutionFolders_TablesDAL.UserId = Security.UserID;
SolutionFolders_TablesDAL.FolderID = int.Parse(this.cmbSolutionFolders.SelectedValue.ToString());
SolutionFolders_TablesDAL.FolderName = this.cmbSolutionFolders.Text;
foreach (DataGridViewRow myRow in this.dvgUnMappedTables.Rows)
{
DataGridViewCheckBoxCell myCell = (DataGridViewCheckBoxCell)myRow.Cells["clmSelect"];
if (myCell.Value.ToString() == "1")
{
myRows = (DataRowView)myRow.DataBoundItem;
SolutionFolders_TablesDAL.TableID = int.Parse(myRows["ID"].ToString());
SolutionFolders_TablesDAL.TableName = myRows["TableName"].ToString();
SolutionFolders_TablesDAL.Insert();
}
}
}
catch (Exception ex)
{
}
this.getMappedTables();
this.GetSelectDB_Tables();
}
void WithdrawDBTable()
{
try
{
SolutionFolders_TablesDAL SolutionFolders_TablesDAL = new SolutionFolders_TablesDAL();
DataRowView myRows;
SolutionFolders_TablesDAL.FolderID = int.Parse(this.cmbSolutionFolders.SelectedValue.ToString());
foreach (DataGridViewRow myRow in this.dvgMappedTables.Rows)
{
DataGridViewCheckBoxCell myCell = (DataGridViewCheckBoxCell)myRow.Cells["clmSelectMapped"];
if (myCell.Value.ToString() == "1")
{
myRows = (DataRowView)myRow.DataBoundItem;
SolutionFolders_TablesDAL.TableID = int.Parse(myRows["ID"].ToString());
SolutionFolders_TablesDAL.Delete(SolutionFolders_TablesDAL.FolderID,SolutionFolders_TablesDAL.TableID);
}
}
}
catch (Exception ex)
{
}
this.getMappedTables();
this.GetSelectDB_Tables();
}
void getMappedTables()
{
try
{
//DataTable myDataTable_SolutionsDBTables = new SolutionsDBTablesDAL().getList_Search(10000, 1, " SolutionsDBID= " + this.cmbSolutionsDB.SelectedValue.ToString(), "TableName");
DataTable myDataTable_SolutionsDBTables = new SolutionFolders_TablesDAL().getMappedTables(int.Parse(this.cmbSolutions.SelectedValue.ToString()),
int.Parse(this.cmbSolutionsDB.SelectedValue.ToString()),
int.Parse(this.cmbSolutionFolders.SelectedValue.ToString()));
if (myDataTable_SolutionsDBTables != null)
{
this.SolutionsMappedDBTables_bindingSource.DataSource = myDataTable_SolutionsDBTables;
}
if (this.SolutionsMappedDBTables_bindingSource.DataSource != null)
{
this.dvgMappedTables.DataSource = this.SolutionsMappedDBTables_bindingSource;
this.dvgMappedTables.Columns["clmTableName"].DataPropertyName = "TableName";
}
this.dvgMappedTables.Refresh();
this.dvgMappedTables.Update();
}
catch (Exception ex)
{
}
}
void getSelectedTableFolder()
{
try
{
DataTable myDataTable_TableFolder = new SolutionFolders_TablesDAL().getTableFolderInfo(int.Parse(this.cmbSolutions.SelectedValue.ToString()), this.cmbDBTables.Text);
if (myDataTable_TableFolder !=null && myDataTable_TableFolder.Rows.Count >0)
{
DataRow myRow = myDataTable_TableFolder.Rows[0];
this.CurrentFolderName = myRow["FolderName"].ToString();
this.CurrentFolderId = int.Parse(myRow["FolderId"].ToString());
this.txtGenerateBESaveIn.Text = this.txtBaseFolder.Text + "\\" + myRow["FolderName"].ToString();
this.txtGenerateBENamespace.Text = myRow["NamespaceFormat"].ToString().Replace("{Parent}",this.txtProjectNamespace.Text).Replace("{FolderName}",myRow["FolderName"].ToString());
}
}
catch (Exception ex)
{
}
}