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());
        }