private void frmNewJob_Load(object sender, EventArgs e)
{
using (myQualityClass _myClass = new myQualityClass(Program._cnnString))
{
DataTable T = _myClass.getSqlData("select max(jobid) from jobs");
int i = 0;
try
{
i = int.Parse(T.Rows[0].ToString());
}
catch
{
i++;
}
txtJobId.Text = i.ToString("###,###,000");
}
}
private void btnGetDataBases_Click(object sender, EventArgs e)
{
try
{
using (myQualityClass _myClass = new myQualityClass(Program._cnnStringMaster) )
{
DataTable T= _myClass.getSqlData("SELECT name from sys.databases where name like 'db%'");
this.cmbSqlDataBases.Items.Clear();
lsbSqlFild.Items.Clear();
foreach (DataRow R in T.Rows)
{
this.cmbSqlDataBases.Items.Add(R[0].ToString());
}
T.Dispose();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
//Save Jobs
try
{
using (myQualityClass _qualityClass = new myQualityClass(Program._cnnString))
{
StringBuilder jobId = new StringBuilder(txtJobId.Text);
StringBuilder jobName = new StringBuilder(txtJobName.Text.Trim());
_qualityClass.addNewJob(jobId,jobName);
jobId.Clear();
jobName.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
