protected void DiseaseDataSource_Inserted(object sender, SqlDataSourceStatusEventArgs e)
{
string Data_Id = e.Command.Parameters["@IdReturn"].Value.ToString();
string txt2 = txtValues.Text;
string[] newlist = txt2.Split(new Char[] { ';', '\\' }, StringSplitOptions.RemoveEmptyEntries);
string[] IdSstring = new String[newlist.Length];
System.Data.DataTable dt = new System.Data.DataTable();
string bush = string.Empty;
SqlConnection connection = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\DiseaseDatabase.mdf;Integrated Security=True");
connection.Open();
DataTable dt3 = new DataTable();
SqlCommand sqlCmd3 = new SqlCommand("SELECT * from Symptoms ", connection);
// sqlCmd3.Parameters.AddWithValue("@username", user);
SqlDataAdapter sqlDa3 = new SqlDataAdapter(sqlCmd3);
sqlDa3.Fill(dt3);
int comcheck = 0;
int Incre = 0;
int DSincr = 0;
while (comcheck < newlist.Length)
{
for (int hu = 0; hu < dt3.Rows.Count; hu++)
{
if (newlist[comcheck] == dt3.Rows[hu]["Name"].ToString())
{
IdSstring[Incre] = dt3.Rows[hu]["Id"].ToString();
Incre++;
break;
}
}
comcheck++;
}
for (int q = 0; q < IdSstring.Length; q++)
{
string Sym_Check = "Symp" + q;
Disease_SymptomsDataSource.InsertParameters.Add(Sym_Check, newlist[q]);
Disease_SymptomsDataSource.InsertCommandType = SqlDataSourceCommandType.Text;
Disease_SymptomsDataSource.InsertCommand = "INSERT INTO Disease_Symptoms(Disease_Id, Symptom_Id) VALUES(" + Data_Id + ", " + IdSstring[q] + ")";
Disease_SymptomsDataSource.Insert();
}
string txt = Aliases.Text;
string[] lst = txt.Split(new Char[] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries);
//int a = lst.Length;
for (int a = 0; a < lst.Length; a++)
{
string check = "AliasName" + a;
AliasesDataSource.InsertParameters.Add(check, lst[a]);
AliasesDataSource.InsertCommandType = SqlDataSourceCommandType.Text;
AliasesDataSource.InsertCommand = "INSERT INTO Aliases(Name, Disease_Id) VALUES(@" + check + ", " + Data_Id + ")";
AliasesDataSource.Insert();
}
CheckBoxList chkbx = (CheckBoxList)FindControl("CheckBoxList1");
for (int b = 0; b < 5; b++)
{
string check1 = "Vector_Id" + b;
if (CheckBoxList1.Items[b].Selected)
{
Disease_VectorsDataSource.InsertParameters.Add(check1, CheckBoxList1.Items[b].Value);
Disease_VectorsDataSource.InsertCommandType = SqlDataSourceCommandType.Text;
Disease_VectorsDataSource.InsertCommand = "INSERT INTO Disease_Vectors(Disease_Id, Vector_Id) VALUES(" + Data_Id + ", @" + check1 + ")";
Disease_VectorsDataSource.Insert();
}
}
}
protected void DiseaseDataSource_Inserted(object sender, SqlDataSourceStatusEventArgs e)
{
String Data_Id = Request.QueryString["boosh"];
string txt2 = txtValues.Text;
string[] newlist = txt2.Split(new Char[] { ';', '\\' }, StringSplitOptions.RemoveEmptyEntries);
string[] IdSstring = new String[newlist.Length];
System.Data.DataTable dt = new System.Data.DataTable();
string bush = string.Empty;
SqlConnection connection = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\DiseaseDatabase.mdf;Integrated Security=True");
connection.Open();
Disease_SymptomsDataSource.DeleteCommandType = SqlDataSourceCommandType.Text;
Disease_SymptomsDataSource.DeleteCommand = "DELETE FROM Disease_Symptoms WHERE [Disease_Id] = " + Data_Id + "";
Disease_SymptomsDataSource.Delete();
DataTable dt3 = new DataTable();
SqlCommand sqlCmd3 = new SqlCommand("SELECT * from Symptoms ", connection);
// sqlCmd3.Parameters.AddWithValue("@username", user);
SqlDataAdapter sqlDa3 = new SqlDataAdapter(sqlCmd3);
sqlDa3.Fill(dt3);
int comcheck = 0;
int Incre = 0;
int DSincr = 0;
while (comcheck < newlist.Length)
{
for (int hu = 0; hu < dt3.Rows.Count; hu++)
{
if (newlist[comcheck] == dt3.Rows[hu]["Name"].ToString())
{
IdSstring[Incre] = dt3.Rows[hu]["Id"].ToString();
Incre++;
break;
}
}
comcheck++;
}
for (int q = 0; q < IdSstring.Length; q++)
{
string Sym_Check = "Symp" + q;
Disease_SymptomsDataSource.InsertParameters.Add(Sym_Check, newlist[q]);
Disease_SymptomsDataSource.InsertCommandType = SqlDataSourceCommandType.Text;
Disease_SymptomsDataSource.InsertCommand = "INSERT INTO Disease_Symptoms(Disease_Id, Symptom_Id) VALUES(" + Data_Id + ", " + IdSstring[q] + ")";
Disease_SymptomsDataSource.Insert();
}
String s = Request.QueryString["boosh"];
string txt = TextBox5.Text;
string[] lst = txt.Split(new Char[] { '\n', '\r', ' ' }, StringSplitOptions.RemoveEmptyEntries);
string[] Add = new String[lst.Length];;
//int a = lst.Length;
DataTable dtAliases = new DataTable();
DataTable dtAl = new DataTable();
SqlCommand sqlCmdAl = new SqlCommand("SELECT * from Aliases WHERE Disease_Id = " + s + "", connection);
sqlCmdAl.Parameters.AddWithValue("@username", s);
SqlDataAdapter sqlDaAl = new SqlDataAdapter(sqlCmdAl);
//SqlDataSource3.DeleteParameters.Add(check1, Delete[aop]);
SqlDataSource3.DeleteCommandType = SqlDataSourceCommandType.Text;
SqlDataSource3.DeleteCommand = "DELETE FROM Aliases WHERE Aliases.Disease_Id = " + s + "";
SqlDataSource3.Delete();
for (int a = 0; a < lst.Length; a++)
{
string check = "AliasName" + a;
SqlDataSource3.InsertParameters.Add(check, lst[a]);
SqlDataSource3.InsertCommandType = SqlDataSourceCommandType.Text;
SqlDataSource3.InsertCommand = "INSERT INTO Aliases(Name, Disease_Id) VALUES(@" + check + ", " + Data_Id + ")";
SqlDataSource3.Insert();
}
DataTable dtVe = new DataTable();
SqlCommand sqlCmdVe = new SqlCommand("SELECT * from Disease_Vectors WHERE Disease_Id = " + s + "", connection);
sqlCmdAl.Parameters.AddWithValue("@username", s);
SqlDataAdapter sqlDaVe = new SqlDataAdapter(sqlCmdVe);
sqlDaVe.Fill(dtVe);
CheckBoxList chkbx = (CheckBoxList)FindControl("CheckBoxList1");
//SqlDataSource4.DeleteParameters.Add(check1, Delete1[b]);
SqlDataSource4.DeleteCommandType = SqlDataSourceCommandType.Text;
SqlDataSource4.DeleteCommand = "DELETE FROM Disease_Vectors WHERE [Disease_Id] = " + s + "";
SqlDataSource4.Delete();
for (int fo = 0; fo < 5; fo++)
{
string check12 = "Vector_Id" + fo;
if (CheckBoxList1.Items[fo].Selected)
{
SqlDataSource4.InsertParameters.Add(check12, CheckBoxList1.Items[fo].Value);
SqlDataSource4.InsertCommandType = SqlDataSourceCommandType.Text;
SqlDataSource4.InsertCommand = "INSERT INTO Disease_Vectors(Disease_Id, Vector_Id) VALUES(" + Data_Id + ", @" + check12 + ")";
SqlDataSource4.Insert();
}
}
//"INSERT INTO Disease_Vectors(Disease_Id, Vector_Id) VALUES(" + Data_Id + ", @" + check1 + ")"
//String myStringVariable = "Disease Updated";
}
