public void LoadDatabases()
{
EntityBusiness business = new EntityBusiness();
var databases = business.GetAllServers();
dgvDatabases.DataSource = databases;
dgvDatabases.ClearSelection();
}
private void LoadEnvironments()
{
EntityBusiness edata = new EntityBusiness();
var serverlist =
edata.GetServerList().ToList();
if (serverlist != null)
{
_envlist = serverlist;
foreach (var s in serverlist)
{
ToolStripItem item = new ToolStripMenuItem();
item.Text = s.DbAlias;
item.Name = s.ServerID.ToString();
item.Click += new EventHandler(item_Click);
tsbtnExeOn.DropDownItems.Add(item);
ToolStripItem item2 = new ToolStripMenuItem();
item2.Text = s.DbAlias;
item2.Name = s.ServerID.ToString();
item2.Click += new EventHandler(itemcheck_Click);
tsbtnExeOnSelected.DropDownItems.Add(item2);
}
}
ToolStripSeparator tsSeparator = new ToolStripSeparator();
tsbtnExeOn.DropDownItems.Add(tsSeparator);
ToolStripItem itemall = new ToolStripMenuItem();
itemall.Text = "All Environments";
itemall.Name = "all";
itemall.Click += new EventHandler(item_Click);
tsbtnExeOn.DropDownItems.Add(itemall);
}
void LoadExistingServers()
{
EntityBusiness business = new EntityBusiness();
var servers = business.GetServerList();
cmbServerName.DisplayMember = "ServerName";
cmbServerName.ValueMember = "ServerID";
cmbServerName.DataSource = servers;
cmbServerName.SelectedIndex = -1;
}
private void LoadLastSavedSession()
{
try
{
EntityBusiness entityBusiness = new EntityBusiness();
var lastsess = entityBusiness.GetLastTableScriptSession();
selectedtables = lastsess;
dgvtblSelected.DataSource = selectedtables;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void LoadDataBases()
{
EntityBusiness edata = new EntityBusiness();
var serverlist = edata.GetServerList();
//Column5.DisplayMember = "Database";
//Column5.ValueMember = "ServerID";
Column3.DataSource = serverlist;
DataGridViewComboBoxColumn ComboColumn = (DataGridViewComboBoxColumn)(dataGridView1.Columns[2]);
ComboColumn.DataSource = serverlist;
ComboColumn.DisplayMember = "Database";
ComboColumn.ValueMember = "ServerID";
}
void AddNewServer()
{
ServerModel ns = new ServerModel();
ns.ServerName = cmbServerName.Text.Trim();
ns.Username = txtUsername.Text.Trim();
ns.Password = txtPassword.Text.Trim();
ns.Database = cmbDatabase.Text.Trim();
ns.DbAlias = txtDatabase.Text.Trim();
EntityBusiness business = new EntityBusiness();
int res = business.AddNewDbServer(ns);
ClearForm();
if (res > 0)
MessageBox.Show("Details saved succesfully", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void LoadDatabases()
{
cmbDatabase.SelectedIndexChanged -= cmbDatabase_SelectedIndexChanged;
EntityBusiness entityBusiness = new EntityBusiness();
var dbs = entityBusiness.GetServerList();
cmbDatabase.ComboBox.DisplayMember = "DbAlias";
cmbDatabase.ComboBox.ValueMember = "ServerID";
cmbDatabase.ComboBox.DataSource = dbs;
string mainserver = new ConfigurationHelper().GetConfigurationValue("mainserver");
//string mainserver = System.Configuration.ConfigurationSettings.AppSettings["mainserver"];
if (mainserver != "0" && mainserver != "")
cmbDatabase.ComboBox.SelectedValue = Convert.ToInt32(mainserver);
else
cmbDatabase.ComboBox.SelectedIndex = -1;
cmbDatabase.SelectedIndexChanged += cmbDatabase_SelectedIndexChanged;
}
void RemoveDatabase()
{
EntityBusiness entityBusiness = new EntityBusiness();
int id = Convert.ToInt32(dgvDatabases.SelectedRows[0].Cells[1].Value);
entityBusiness.RemoveServer(id);
LoadDatabases();
}
public string GenerateDataScript()
{
DataGenType dtype = DataGenType.Insert;
if (rbDInsert.Checked)
dtype = DataGenType.Insert;
else if (rbDUpdate.Checked)
dtype = DataGenType.Update;
else if (rbDTruncate.Checked)
dtype = DataGenType.Truncate;
else if (rbDTruncateInsert.Checked)
dtype = DataGenType.TruncateInsert;
ScriptBusiness scriptBusiness = new ScriptBusiness();
var server = new EntityBusiness().GetServerList().Where(x=> x.ServerID == Convert.ToInt32(tscomserver.ComboBox.SelectedValue)).First();
string query = scriptBusiness.GenerateTableData(server, dtype, selectedtables);
return query;
}
private void btnRemove_Click(object sender, EventArgs e)
{
dgvtblSelected.EndEdit();
var remlist = new List<int>();
foreach (DataGridViewRow rw in dgvtblSelected.Rows)
{
if (Convert.ToBoolean(rw.Cells[1].Value))
{
remlist.Add(Convert.ToInt32(rw.Cells[0].Value));
}
}
EntityBusiness entityBusiness = new EntityBusiness();
entityBusiness.RemoveTabelObject(remlist.Select(x=> new TableModel()
{
TableId = x
}).ToList());
foreach (var id in remlist)
{
selectedtables.Remove(selectedtables.Where(x => x.TableId == id).First());
}
selectedtables = selectedtables.OrderBy(x => x.TableName).ToList();
dgvtblSelected.DataSource = selectedtables;
}
private void tscomserver_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (tscomserver.ComboBox.Items.Count > 0)
{
if (tscomserver.ComboBox.SelectedIndex != -1)
{
int id = Convert.ToInt32(tscomserver.ComboBox.SelectedValue);
EntityBusiness data = new EntityBusiness();
var servers = data.GetServerList();
maindb = servers.Where(x => x.ServerID == id).FirstOrDefault();
LoadTables();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadDatabases()
{
tscomserver.SelectedIndexChanged -= tscomserver_SelectedIndexChanged;
EntityBusiness entityBusiness = new EntityBusiness();
var dbs = entityBusiness.GetServerList();
tscomserver.ComboBox.DisplayMember = "DbAlias";
tscomserver.ComboBox.ValueMember = "ServerID";
tscomserver.ComboBox.DataSource = dbs;
string mainserver = new ConfigurationHelper().GetConfigurationValue("mainserver");
if (mainserver != "0" && mainserver != "")
{
tscomserver.ComboBox.SelectedValue = Convert.ToInt32(mainserver);
maindb = dbs.Where(x => x.ServerID == Convert.ToInt32(mainserver)).FirstOrDefault();
//LoadOtherDBs(dbs, Convert.ToInt32(mainserver));
}
else
{
tscomserver.ComboBox.SelectedIndex = -1;
//LoadOtherDBs(dbs, 0);
}
tscomserver.SelectedIndexChanged += tscomserver_SelectedIndexChanged;
}
private void cmbDatabase_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cmbDatabase.ComboBox.Items.Count > 0)
{
if (cmbDatabase.ComboBox.SelectedIndex != -1)
{
int id = Convert.ToInt32(cmbDatabase.ComboBox.SelectedValue);
EntityBusiness data= new EntityBusiness();
var servers = data.GetServerList();
AppTimeConfiguration.MainServer = servers.Where(x => x.ServerID == id).FirstOrDefault();
new ConfigurationHelper().AddConfiguration("mainserver",id.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void UpdateDatabases()
{
List<ServerModel> slist = new List<ServerModel>();
dgvDatabases.EndEdit();
foreach (DataGridViewRow row in dgvDatabases.Rows)
{
slist.Add(new ServerModel()
{
ServerID = Convert.ToInt32(row.Cells[1].Value),
IsVisible = Convert.ToBoolean(row.Cells[7].Value)
});
}
EntityBusiness entityBusiness = new EntityBusiness();
entityBusiness.UpdateDatabases(slist);
}
void CompareScript(int rowindex)
{
string spname = dgvSP.Rows[rowindex].Cells[3].Value.ToString();
StoredProcedureBusiness spdata = new StoredProcedureBusiness();
int sourceid = Convert.ToInt32(dgvSP.Rows[rowindex].Cells[5].Value);
int toid = Convert.ToInt32(dgvSP.Rows[rowindex].Cells[6].Value);
var serverlist = new EntityBusiness().GetServerList();
var serversource = serverlist.Where(x => x.ServerID == sourceid).First();
var serverto = serverlist.Where(x => x.ServerID == toid).First();
string leftquery = new StoredProcedureBusiness().GetScript(serversource, spname);
string rightquery = new StoredProcedureBusiness().GetScript(serverto, spname);
frmCompare frm = new frmCompare(leftquery,rightquery);
frm.Show();
}
void RemoveAll()
{
EntityBusiness entityBusiness = new EntityBusiness();
entityBusiness.ClearAllDatabases();
LoadDatabases();
}
void LoadDataBases()
{
EntityBusiness edata = new EntityBusiness();
var serverlist = edata.GetServerList();
DataGridViewComboBoxColumn colsource = (DataGridViewComboBoxColumn)(dgvSP.Columns[5]);
colsource.DataSource = serverlist;
colsource.DisplayMember = "Database";
colsource.ValueMember = "ServerID";
DataGridViewComboBoxColumn colto = (DataGridViewComboBoxColumn)(dgvSP.Columns[6]);
colto.DataSource = serverlist;
colto.DisplayMember = "Database";
colto.ValueMember = "ServerID";
}
public void LoadStoredProcedures(DateTime date)
{
EntityBusiness edata = new EntityBusiness();
var splist = edata.GetDailyStoredProcedures(date);
dgvSP.DataSource = splist;
var ms = AppTimeConfiguration.MainServer.ServerID;
foreach (DataGridViewRow rw in dgvSP.Rows)
{
rw.Cells[5].Value = ms;
rw.Cells[6].Value = ms;
}
}
private void frmHome_Load(object sender, EventArgs e)
{
try
{
LoadDatabases();
string serverid = new ConfigurationHelper().GetConfigurationValue("mainserver");
EntityBusiness data = new EntityBusiness();
var servers = data.GetServerList();
var server = servers.Where(x => x.ServerID == Convert.ToInt32(serverid)).FirstOrDefault();
if (server != null)
{
AppTimeConfiguration.MainServer = server;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void AddTables()
{
EntityBusiness entityBusiness = new EntityBusiness();
dgvallTables.EndEdit();
var tbllist = new List<TableModel>();
foreach (DataGridViewRow rw in dgvallTables.Rows)
{
if (Convert.ToBoolean(rw.Cells[1].Value))
tbllist.Add(new TableModel()
{
TableId = Convert.ToInt32(rw.Cells[0].Value.ToString()),
bSelected = true,
TableName = rw.Cells[2].Value.ToString()
});
}
var newtables =
tbllist.Where(y => !selectedtables.Select(x => x.TableId).Contains(y.TableId))
.ToList();
entityBusiness.AddTableObject(newtables);
selectedtables.AddRange(newtables);
selectedtables = selectedtables.OrderBy(x => x.TableName).ToList();
dgvtblSelected.DataSource = selectedtables;
}
void AddNewStoredProcedure()
{
string spname = txtspname.Text.Trim();
StoredProcedureBusiness spData = new StoredProcedureBusiness();
var splist = spData.GetStoredProcedureList(AppTimeConfiguration.MainServer);
if (splist.Select(x => x.SPName.ToLower()).Contains(spname.ToLower()))
{
string procname = splist.Where(x => x.SPName.ToLower() == spname.ToLower()).First().SPName;
EntityBusiness edata = new EntityBusiness();
SPModel sp = new SPModel();
sp.SPName = procname;
sp.SPDate = dtpScriptDate.Value;
sp.CreatedDate = DateTime.Now;
long res = edata.AddNewSP(sp);
if (res != -1)
{
LoadStoredProcedures(dtpScriptDate.Value);
txtspname.Clear();
}
else
{
MessageBox.Show("Stored Procedures already exists.", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Stored Procedures does not exists in current database.", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation);
}
}
void SelectServer()
{
if (cmbServerName.SelectedIndex >= 0)
{
if (cmbServerName.Items.Count > 0)
{
EntityBusiness business = new EntityBusiness();
var server = business.SelectServer(Convert.ToInt32(cmbServerName.SelectedValue));
if (server != null)
{
txtUsername.Text = server.Username;
txtPassword.Text = server.Password;
}
}
}
}
void LoadStoredProcedures(DateTime date)
{
EntityBusiness edata = new EntityBusiness();
var splist = edata.GetDailyStoredProcedures(date);
dgvSP.DataSource = splist;
}
private void tsbtnRemove_Click(object sender, EventArgs e)
{
try
{
dgvSP.EndEdit();
EntityBusiness entityBusiness = new EntityBusiness();
foreach (DataGridViewRow rw in dgvSP.Rows)
{
if (Convert.ToBoolean(rw.Cells[2].Value))
entityBusiness.RemoveStoredProcedure(Convert.ToInt64(rw.Cells[0].Value));
}
LoadStoredProcedures(dtpScriptDate.Value);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
void ImportProcedures()
{
List<Int64> idlist = new List<Int64>();
foreach (DataGridViewRow row in dgvSP.Rows)
{
if(Convert.ToBoolean(row.Cells[2].Value) == true)
idlist.Add(Convert.ToInt64(row.Cells[0].Value));
}
EntityBusiness entityBusiness = new EntityBusiness();
entityBusiness.ImportStoredProcedures(idlist, _parentForm.dtpScriptDate.Value);
}
