public UserBloodTransfusee ShowTransfuse()
{
UserBloodTransfusee transfuse = new UserBloodTransfusee();
string query = "Select * From BloodTransfusion B where B.UserID = '" + User.UserID + "'";
if (MyCon.State == 0)
{
MyCon.Open();
}
SqlCommand cmd = new SqlCommand(query, MyCon);
try
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
transfuse.tt = reader[1].ToString();
transfuse.ab = reader[2].ToString();
transfuse.h = reader[3].ToString();
transfuse.dot = DateTime.Parse(reader[4].ToString());
transfuse.p = int.Parse(reader[5].ToString());
transfuse.b = reader[6].ToString();
transfuse.dnt = DateTime.Parse(reader[7].ToString());
}
}
catch (Exception e)
{
}
MyCon.Close();
return(transfuse);
}
//UserTranfuseController
public int ID()
{
UserBloodTransfusee ubt;
ubt = new UserBloodTransfusee();
return(ubt.ShowID());
}
public void UpdatingTransfusion(int a, string b, string c, string d, DateTime e, int f, string g, DateTime h)
{
UserBloodTransfusee u = new UserBloodTransfusee();
u.UpdateTranfuse(a, b, c, d, e, f, g, h);
}
public UserBloodTransfusee TransfusionData()
{
UserBloodTransfusee ut = new UserBloodTransfusee();
return(ut.ShowTransfuse());
}
