private void MethodEdit_Load(object sender, EventArgs e)
{
methodeditmethodnametextbox.Text = methodentity.getmethodname();
for (int i = 0; i < methodentity.getsettinglist().Count; i++)
{
methodeditparamatercombox.Items.Add(((Settingentity)methodentity.getsettinglist()[i]).getparamatername());
}
}
private void Method_Load(object sender, EventArgs e)
{
if (methodtemp.getsettinglist().Count > 0)
{
methodnamevalue.Text = methodtemp.getmethodname();
Paramaternumbertextbox.Text = methodtemp.getsettinglist().Count.ToString();
String temp = "";
for (int i = 0; i < methodtemp.getsettinglist().Count; i++)
{
temp = temp + ((Settingentity)methodtemp.getsettinglist()[i]).getparamatername();
if (i != methodtemp.getsettinglist().Count - 1)
{
temp = temp + ",";
}
}
namevalue.Text = temp;
}
}
private void save_Click(object sender, EventArgs e)
{
if (editflag == 1)
{
MySqlDataReader tempsqlreader = databaseoperator.select("methodtable", "Methodname", methodtemp.getmethodname());
ArrayList deletelist = new ArrayList();
while (tempsqlreader.Read())
{
deletelist.Add((String)tempsqlreader.GetValue(3));
}
databaseoperator.connectdatabase();
databaseoperator.opendatabase();
databaseoperator.deletedata("methodtable", "Methodname", methodtemp.getmethodname());
for (int i = 0; i < deletelist.Count; i++)
{
databaseoperator.deletedata("settingentitytable", "Paramaterindex", (String)deletelist[i]);
databaseoperator.deletedata("resulttable", "Resultvalueindex", (String)deletelist[i]);
databaseoperator.deletedata("rectangletable", "Rectangleindex", (String)deletelist[i]);
databaseoperator.deletedata("setzonetable", "Setzoneindex", (String)deletelist[i]);
}
databaseoperator.closedatabase();
}
bool flagtemp = true;
methodtemp.getcameraandsourcesetting().setcameraname(devicename);
methodtemp.getcameraandsourcesetting().setresolution(resolution);
methodtemp.getcameraandsourcesetting().setbrightnes(brightness);
methodtemp.getcameraandsourcesetting().setcontrast(contrast);
methodtemp.getcameraandsourcesetting().setsaturation(saturation);
for (int k = 0; k < methodlisttemp.Count; k++)
{
MethodEntity temp = (MethodEntity)methodlisttemp[k];
if (temp.getmethodname() == methodtemp.getmethodname())
{
flagtemp = false;
break;
}
}
if (flagtemp == true)
{
methodlisttemp.Add(methodtemp);
}
for (int databasei = 0; databasei < methodtemp.getsettinglist().Count; databasei++)
{
string paramaterindex = methodtemp.getmethodname().ToString() + ((Settingentity)methodtemp.getsettinglist()[databasei]).getparamatername().ToString();
databaseoperator.insertdata("Methodtable", "Methodname,Paramaters,Paramaterindex,Brightness,Contrast,Saturation,Cameraname,Resolution, Sensitivevalue,Adjustvalue", "'" + methodtemp.getmethodname().ToString() + "'" + "," + "'" + ((Settingentity)methodtemp.getsettinglist()[databasei]).getparamatername().ToString() + "'" + "," + "'" + paramaterindex + "'" + "," + ((Cameraandsourcesetting)methodtemp.getcameraandsourcesetting()).getbrightness() + "," + ((Cameraandsourcesetting)methodtemp.getcameraandsourcesetting()).getcontrast() + "," + ((Cameraandsourcesetting)methodtemp.getcameraandsourcesetting()).getsaturation() + "," + "'" + ((Cameraandsourcesetting)methodtemp.getcameraandsourcesetting()).getcameraname() + "'" + "," + methodtemp.getcameraandsourcesetting().getresolution() + "," + methodtemp.getsensitive() + "," + methodtemp.getadjustvalue());
string settingtablevalue = "'" + ((Settingentity)methodtemp.getsettinglist()[databasei]).getparamatername().ToString() + "'" + "," + "'" + ((Settingentity)methodtemp.getsettinglist()[databasei]).getlinevalue().ToString() + "'" + "," + ((Settingentity)methodtemp.getsettinglist()[databasei]).getshuttertimes().ToString() +
"," + ((Settingentity)methodtemp.getsettinglist()[databasei]).getreadytime().ToString() + "," + "'" + methodtemp.getmethodname().ToString() + "'" + "," + "'" + paramaterindex.ToString() + "'" + "," + "'" + paramaterindex.ToString() + "'" + "," + "'" + paramaterindex.ToString() + "'";
databaseoperator.insertdata("Settingentitytable", "Paramatername,Cline,Shuttertime,Readytime,Methodname,Resultvalueindex,Rectangleindex,Paramaterindex",
settingtablevalue);
string rectangletablevalue = "'" + paramaterindex + "'" + "," + ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getx().ToString() + "," + ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).gety().ToString() + "," + ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getimagewidth().ToString() + "," + ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getimageheight().ToString();
databaseoperator.insertdata("Rectangletable", "Rectangleindex,X,Y,Width,Height", rectangletablevalue);
for (int resulti = 0; resulti < ((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist().Count; resulti++)
{
//string resultvalueindex = paramaterindex + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultname().ToString();
string resultvalueindex = paramaterindex;
string resulttablevalue = "'" + resultvalueindex + "'" + "," + "'" + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultname().ToString() + "'" + "," + "'" + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultstartvalue().ToString() + "'" + "," + "'" + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultendvalue().ToString() + "'" + "," + "'" + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultvalue() + "'";
databaseoperator.insertdata("Resulttable", "Resultvalueindex,Resultname,Resultstartvalue,Resultendvalue,Resultvalue", resulttablevalue);
}
for (int setzonei = 0; setzonei < ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist().Count; setzonei++)
{
string setzonetablevalue = "'" + ((Settingentity)methodtemp.getsettinglist()[databasei]).getparamatername() + "'" + "," + "'" + paramaterindex + "'" + "," + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonepositionx().ToString() + "," + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonepositiony().ToString() + "," + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonepositionwidth().ToString() + "," + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonepositionheight().ToString() + "," + "'" + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonecategory() + "'";
databaseoperator.insertdata("SetZonetable", "Paramater,Setzoneindex,ZonepositionX,ZonepositionY,ZonepositionWidth, ZonepositionHeight, Zonecategory", setzonetablevalue);
}
}
formtemp.OnLoad();
form.getclosingmethod();
form.Dispose();
}
