Example #1
0
        private void btnXacNhan_Click(object sender, EventArgs e)
        {
            string TenBN    = txtTenBN.Text;
            string GT       = txtGioiTinh.Text;
            string NgaySinh = dtpNgaySinh.Value.ToString("MM/dd/yyyy");
            int    SDT      = Convert.ToInt32(txtSDT.Text);
            string Email    = txtEmail.Text;
            string DiaChi   = txtDiaChi.Text;
            string GhiChu   = txtGhiChu.Text;
            string NgayKham = lbNgay.Text;

            string[] formats = { "dd/MM/yyyy", "dd-MMM-yyyy", "yyyy-MM-dd",
                                 "dd-MM-yyyy", "M/d/yyyy",    "dd MMM yyyy" };
            string   converted = DateTime.ParseExact(NgayKham, formats, CultureInfo.InvariantCulture, DateTimeStyles.None).ToString("MM/dd/yyyy");
            BacSi    bacSi     = new BacSi(-1, lbTenBS.Text, "", -1, -1, -1, "");
            BenhNhan benhNhan  = new BenhNhan(-1, TenBN, GT, NgaySinh, SDT, Email, DiaChi);
            PhieuHen phieuHen  = new PhieuHen(-1, -1, lbThoiGian.Text, GhiChu, converted);

            if (phieuhen.PhieuHen_Insert(bacSi, benhNhan, phieuHen) == true)
            {
                MessageBox.Show("Đặt lịch thành công, chi tiết xem tại mục dành cho bệnh nhân", "Thông báo");
            }
            else
            {
                MessageBox.Show("ERROR");
            }
        }
 public bool PhieuHen_Insert(BacSi bacSi, BenhNhan benhNhan, PhieuHen phieuHen)
 {
     try
     {
         string    query  = "BenhNhan_Select N'" + bacSi.TenBS + "',N'" + benhNhan.TenBN + "','" + phieuHen.ThoiGian + "','" + phieuHen.NgayKham + "',N'" + phieuHen.GhiChu + "',N'" + benhNhan.GioiTinh + "','" + benhNhan.NgaySinh + "','" + benhNhan.SDT + "','" + benhNhan.Email + "',N'" + benhNhan.DiaChi + "'";
         DataTable result = DataProvider.Instance.ExecuteQuery(query);
         return(true);
     }
     catch (Exception e)
     { }
     return(false);
 }
        public ActionResult ChiTietPH(int id)
        {
            PhieuHen phieuhen = (from s in db.PhieuHens
                                 orderby s.id_PhieuHen descending
                                 where s.id_PhieuHen == id
                                 select s).SingleOrDefault();

            ViewBag.id_PhieuHen = phieuhen.id_PhieuHen;
            if (phieuhen == null)
            {
                Response.StatusCode = 404;
            }
            return(View(phieuhen));
        }
 public bool PhieuHen_Insert(BacSi bacSi, BenhNhan benhNhan, PhieuHen phieuHen)
 {
     return(phieuhen.PhieuHen_Insert(bacSi, benhNhan, phieuHen));
 }
Example #5
0
        public ActionResult GetFile(string id, string typeReport)
        {
            byte[] pdf = null;
            con.Open();
            SqlCommand cmd = con.CreateCommand();

            cmd.CommandText = "Select * from DangKyThongTin where Id = 1";
            SqlDataReader abc = cmd.ExecuteReader();

            while (abc.Read())
            {
                string col = abc["Ho"].ToString();
            }

            string path = System.IO.Path.GetDirectoryName(
                System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase).Replace("file:\\", "");

            try
            {
                string json = "";
                string type = "";
                if (typeReport.Equals("DANG_KY_DU_TUYEN"))
                {
                    type = "DANG_KY_DU_TUYEN";
                    DangKyThongTin dangKyThongTin = new DangKyThongTin();
                    dangKyThongTin.Id                = 0;
                    dangKyThongTin.ViTriDuTuyen      = "ViTriDuTuyen";
                    dangKyThongTin.DonViDuTuyen      = "DonViDuTuyen";
                    dangKyThongTin.HoTen             = "Trần Văn Hậu ABC";
                    dangKyThongTin.NgaySinh          = "24/05/1997";
                    dangKyThongTin.MaDuThi           = "ABC";
                    dangKyThongTin.GioiTinh          = true;
                    dangKyThongTin.DanToc            = "Kinh";
                    dangKyThongTin.TonGiao           = "TC";
                    dangKyThongTin.CMND              = "163363955";
                    dangKyThongTin.NgayCapCMNDString = DateTime.Now.ToString("dd/MM/yyyy");
                    dangKyThongTin.NoiCapCMND        = "NAM DINH";
                    dangKyThongTin.DienThoaiLienHe   = "0123456789";
                    dangKyThongTin.Email             = "*****@*****.**";
                    dangKyThongTin.QueQuan           = "Nam Dinh";
                    dangKyThongTin.HoKhauThuongTru   = "Nam Dinh";
                    dangKyThongTin.ChoOHienNay       = "Ha Dong Ha Noi";
                    dangKyThongTin.SucKhoe           = "Tot";
                    dangKyThongTin.ChieuCao          = "123";
                    dangKyThongTin.CanNang           = "123";
                    dangKyThongTin.BanThanHienNay    = "ABC";
                    dangKyThongTin.TrinhDoVanHoa     = "BCD";
                    dangKyThongTin.TrinhDoChuyenMon  = "BCD";
                    dangKyThongTin.LoaiHinhDaoTao    = "LoaiHinhDaoTao";
                    dangKyThongTin.NgayDangKyString  = ".........., ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month.ToString() + " " + DateTime.Now.Year.ToString();

                    json = JsonConvert.SerializeObject(dangKyThongTin, Newtonsoft.Json.Formatting.None,
                                                       new JsonSerializerSettings
                    {
                        NullValueHandling = NullValueHandling.Ignore
                    });
                }
                else
                {
                    type = "PHIEU_HEN";
                    PhieuHen phieuHen = new PhieuHen();
                    phieuHen.id             = 0;
                    phieuHen.MaHoSo         = "ABC";
                    phieuHen.HoVaTen        = "Tran Van Hau";
                    phieuHen.NgaySinh       = "24/05/1997";
                    phieuHen.CMND           = "163363955";
                    phieuHen.DienThoai      = "123456789";
                    phieuHen.Email          = "*****@*****.**";
                    phieuHen.ViTriDuTuyen   = "ViTriDuTuyen";
                    phieuHen.DonViDuTuyen   = "DonViDuTuyen";
                    phieuHen.NgayHenNopHoSo = DateTime.Now.ToString("dd/MM/yyyy");


                    json = JsonConvert.SerializeObject(phieuHen, Newtonsoft.Json.Formatting.None,
                                                       new JsonSerializerSettings
                    {
                        NullValueHandling = NullValueHandling.Ignore
                    });
                }
                string base64  = Utils.Base64Encode(json);
                var    process = Process.Start(path + "\\pdf\\App.exe", type + " " + base64 + " " + id);
                Console.WriteLine(path);
                if (process == null) // failed to start
                {
                    //return InternalServerError();
                }
                else // Started, wait for it to finish
                {
                    process.WaitForExit();
                    pdf = System.IO.File.ReadAllBytes(path + "\\pdf\\" + id + "value.pdf");
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }

            //return response;
            byte[] byteArray = null;
            if (System.IO.File.Exists(path + "\\pdf\\" + id + "value.pdf"))
            {
                byteArray = System.IO.File.ReadAllBytes(path + "\\pdf\\" + id + "value.pdf");
                System.IO.File.Delete(path + "\\pdf\\" + id + "value.pdf");
            }
            return(new FileContentResult(byteArray, "application/pdf"));
        }