private void UpdatePat(int id)
{
if (profpat.Error == String.Empty)
{
string queryaddPat = "UPDATE Patients SET Firstname=@FN, Surname=@SN,Patronymic=@Pat" +
",Snils=@Sni,Telephone=@Tel,Address=@Addr,Policy=@Pol,Birthday=@Birth WHERE Id_Patient=@Id";
Dictionary <string, object> dictPat = new Dictionary <string, object>()
{
{ "@FN", profpat.FirstName },
{ "@SN", profpat.SurName },
{ "@Pat", profpat.Patronymic },
{ "@Id", profpat.Id },
{ "@Sni", profpat.Snils },
{ "@Tel", profpat.Telephone },
{ "@Addr", profpat.Address },
{ "@Pol", profpat.Policy },
{ "@Birth", Convert.ToDateTime(profpat.Birthday) }
};
WorkWithDb wwd = new WorkWithDb();
wwd.UpdateDb(queryaddPat, dictPat);
}
else
{
MessageBox.Show("Исправте поля");
}
}
private void CreateMedCard(string policy)
{
int id_pat = 0;
string connectionString = ConfigurationManager.ConnectionStrings["ConnectToDb"].ConnectionString;
using (SqlConnection connect = new SqlConnection(connectionString))
{
connect.Open();
string sqlexp = "SELECT * FROM Patients WHERE Policy =@pol";
SqlCommand cmd = new SqlCommand(sqlexp, connect);
cmd.Parameters.AddWithValue("@pol", policy);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
id_pat = reader.GetInt32(0);
}
}
Dictionary <string, object> newmedcard = new Dictionary <string, object>()
{
{ "@Id_P", id_pat },
{ "@D_C", DateTime.Now.Date },
{ "@Ins_Co", 666 }
};
Dictionary <string, object> mc = new Dictionary <string, object>()
{
{ "@Id", id_pat }
};
var query = "INSERT INTO Med_Card (Id_Patient, Date_Created, Institution_Code) VALUES (@Id_P, @D_C, @Ins_Co)";
var query1 = "UPDATE Patients SET Id_Card=(SELECT Id_Card FROM Med_Card WHERE Id_Patient=@Id) WHERE Id_Patient=@Id";
var types = new Queue <SqlDbType>();
types.Enqueue(SqlDbType.Int);
types.Enqueue(SqlDbType.Date);
types.Enqueue(SqlDbType.SmallInt);
WorkWithDb wwd = new WorkWithDb();
wwd.InsertInDb(query, newmedcard, types);
wwd.UpdateDb(query1, mc);
}