public void save2(string UID, string Sugar, string AlergAn, string InfDis, string MedInt, Sheplenya colShepl = null, Profilact colProfilact = null)
{
MySqlConnectionStringBuilder mysqlCSB;
mysqlCSB = new MySqlConnectionStringBuilder();
mysqlCSB.Server = server;
mysqlCSB.Database = database;
mysqlCSB.UserID = UserID;
mysqlCSB.Password = Password;
MySqlConnection con = new MySqlConnection();
con.ConnectionString = mysqlCSB.ConnectionString;
MySqlCommand cmd = new MySqlCommand();
CardPageTwo temp1 = new CardPageTwo();
con.Open();
cmd.Parameters.AddWithValue("@UserID", UID);
cmd.Parameters.AddWithValue("@Sugar", Sugar);
cmd.Parameters.AddWithValue("@InfDis", InfDis);
cmd.Parameters.AddWithValue("@AlergAn", AlergAn);
cmd.Parameters.AddWithValue("@MedInt", MedInt);
cmd.CommandText = "UPDATE signpozn AS SG SET SG.diabet=@Sugar,SG.Infeciya=@InfDis, SG.AlAnam=@AlergAn, SG.AlergiyaLek=@MedInt WHERE SG.ID_pat=@UserID";//
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
}
public CardPageTwo signPozn(string UID)
{
MySqlConnectionStringBuilder mysqlCSB;
mysqlCSB = new MySqlConnectionStringBuilder();
mysqlCSB.Server = server;
mysqlCSB.Database = database;
mysqlCSB.UserID = UserID;
mysqlCSB.Password = Password;
MySqlConnection con = new MySqlConnection();
con.ConnectionString = mysqlCSB.ConnectionString;
MySqlCommand cmd = new MySqlCommand();
CardPageTwo temp1 = new CardPageTwo();
try
{
con.Open();
cmd.Parameters.AddWithValue("@UserID", UID);
cmd.CommandText = "SELECT * FROM signpozn WHERE ID_pat=@UserID";//
cmd.Connection = con;
cmd.ExecuteNonQuery();
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
temp1 = (new CardPageTwo
{
Shugar = dr.GetString("diabet"),
InfectiousDis = dr.GetString("Infeciya"),
AlergiAnam = dr.GetString("AlAnam"),
IntoleranceToDrugs = dr.GetString("AlergiyaLek"),
NumPat = dr.GetString("ID_pat")
});
}
}
con.Close();
}
catch (Exception e) { }
return(temp1);
}
