private void LimCombo_Leave(object sender, EventArgs e)
{
try
{
Common.FormatCombo(LimCombo);
if (LimCombo.Text.Length <= 0)
{
EP.SetError(LimCombo, "Type the File Name First...");
LimCombo.Focus();
return;
}
else if (LimCombo.Text.Length <= 5)
{
EP.SetError(LimCombo, "The name should be More than 5 Letters...");
LimCombo.Focus();
}
else if (((LimCombo.Text.Substring(0, 4)) == "Lim_") || ((LimCombo.Text.Substring(0, 4)) == "LIM_") || ((LimCombo.Text.Substring(0, 4)) == "lim_"))
{
LimCombo.Text = "lim_" + (LimCombo.Text.Substring(4)).ToLower();
EP.Clear();
}
else
{
LimCombo.Text = "lim_" + LimCombo.Text.ToLower();
EP.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show(" LimCombo_Leave @ Error Code:-7013 " + ex.Message);
}
}
private void mnuUpdate_Click(object sender, EventArgs e)
{
mnuNew.Enabled = true;
mnuDelete.Enabled = true;
if (file_Exist == false)
{
try
{
if (LimCombo.Text == "")
{
MessageBox.Show("Give the Name for New File....");
LimCombo.Focus();
return;
}
Common.Open_Connection("lim_db", "conLim");
MySqlCommand cmdTb = new MySqlCommand();
String StrTb = " Pn Float Primary Key,ParameterName VARCHAR(30)," +
" Lower1 VARCHAR(8), Low1 VARCHAR(8),High1 VARCHAR(8),Higher1 VARCHAR(8)," +
" MinV VARCHAR(8),MaxV VARCHAR(8),Unit VARCHAR(10)";
cmdTb.CommandText = "CREATE TABLE " + LimCombo.Text.ToLower() + "(" + StrTb + ")";
cmdTb.Connection = Common.conLim;
cmdTb.ExecuteNonQuery();
Common.conLim.Close();
int i = 0;
Common.Open_Connection("lim_db", "conLim");
MySqlCommand cmd = new MySqlCommand();
for (i = 0; i < limDGV.RowCount - 1; i++)
{
cmd.CommandText = "INSERT INTO " + LimCombo.Text.ToLower() + " VALUES ('" +
limDGV[0, i].Value.ToString() + "','" +
limDGV[1, i].Value.ToString() + "','" +
limDGV[2, i].Value.ToString() + "','" +
limDGV[3, i].Value.ToString() + "','" +
limDGV[4, i].Value.ToString() + "','" +
limDGV[5, i].Value.ToString() + "','" +
limDGV[6, i].Value.ToString() + "','" +
limDGV[7, i].Value.ToString() + "','" +
limDGV[8, i].Value.ToString() + "')";
cmd.Connection = Common.conLim;
cmd.ExecuteNonQuery();
}
Common.conLim.Close();
//file_Exist = true;
Common.Create_OnLog("Normal", "New Limit File Saved.....");
MessageBox.Show("File Saved .....");
Fill_comboBox();
}
catch (Exception ex)
{
MessageBox.Show("mnuUpdate_Click New file @ Error Code:-12012" + ex.Message);
}
}
else if (file_Exist == true)
{
try
{
int Rw = 0;
Common.Open_Connection("lim_db", "conLim");
MySqlCommand cmd = new MySqlCommand();
for (Rw = 0; Rw <= (limDGV.RowCount - 2); Rw++)
{
int x = Convert.ToInt16(limDGV.Rows[Rw].Cells[0].Value);
cmd.CommandText = "UPDATE " + LimCombo.Text.ToLower() + " SET" +
" Lower1 = '" + limDGV.Rows[Rw].Cells[2].Value.ToString() + "'," +
" Low1 = '" + limDGV.Rows[Rw].Cells[3].Value.ToString() + "'," +
" High1 = '" + limDGV.Rows[Rw].Cells[4].Value.ToString() + "'," +
" Higher1 = '" + limDGV.Rows[Rw].Cells[5].Value.ToString() + "'" +
" WHERE Pn = " + x;
cmd.Connection = Common.conLim;
cmd.ExecuteNonQuery();
}
Common.conLim.Close();
Common.Create_OnLog("Normal", "Limit File Saved.....");
MessageBox.Show("New Changes are saved .....");
Fill_comboBox();
}
catch (Exception ex)
{
MessageBox.Show("mnuUpdate_Click existing file @ Error Code:-12012", ex.Message);
}
}
}
