public void CreatePhieuXetNghiem(Medi_PhieuXetNghiem pxn)
{
using (SqlConnection connection = base.GetConnection())
{
SqlCommand command = new SqlCommand("_PhieuXetNghiemUpdate", connection)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@MaPhieu", pxn.MaPhieu);
command.Parameters.AddWithValue("@MaPin", pxn.MaPin);
command.Parameters.AddWithValue("@HoTen", pxn.HoTen);
command.Parameters.AddWithValue("@Tuoi", pxn.Tuoi);
command.Parameters.AddWithValue("@GioiTinh", pxn.GioiTinh);
command.Parameters.AddWithValue("@DiaChi", pxn.DiaChi);
command.Parameters.AddWithValue("@ThoiGianToiKham", pxn.ThoiGianToiKham);
command.Parameters.AddWithValue("@SoDienThoai", pxn.SoDienThoai);
command.Parameters.AddWithValue("@State", pxn.State);
command.Parameters.AddWithValue("@CreateDate", pxn.CreateDate);
command.Parameters.AddWithValue("@Email", pxn.Email);
command.Parameters.AddWithValue("@ID_DoiTuong", pxn.Id_DoiTuong);
command.Parameters.AddWithValue("@Language", pxn.Language);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Kiểm tra lại thông tin khách hàng");
}
command.Dispose();
}
}
public ETO.Medi_PhieuXetNghiem ReceiveHtml()
{
ETO.Medi_PhieuXetNghiem Medi_pxn = new ETO.Medi_PhieuXetNghiem();
Medi_pxn.HoTen = txt_HoTen.Text.Trim();
if (rdb_men.Checked == true)
{
Medi_pxn.GioiTinh = true;
}
else
{
Medi_pxn.GioiTinh = false;
}
Medi_pxn.Tuoi = Convert.ToInt32(txt_Tuoi.Text.Trim());
Medi_pxn.SoDienThoai = txt_SDT.Text.Trim();
Medi_pxn.DiaChi = txt_DiaChi.Text.Trim();
Medi_pxn.Email = txtEmail.Text.Trim();
Medi_pxn.Id_DoiTuong = Convert.ToInt32(ddlDoiTuong.SelectedValue.Trim());
DateTime date1, time1, TG_BatDau;
date1 = rdp_NgayKham.SelectedDate.Value;
if (!rtp_GioKham.DateInput.IsEmpty)
{
time1 = rtp_GioKham.SelectedDate.Value;
TG_BatDau = new DateTime(date1.Year, date1.Month, date1.Day, time1.Hour, time1.Minute, 0);
Medi_pxn.ThoiGianToiKham = TG_BatDau;
}
else
{
TG_BatDau = new DateTime(date1.Year, date1.Month, date1.Day, 0, 0, 0);
Medi_pxn.ThoiGianToiKham = TG_BatDau;
}
Medi_pxn.MaPin = txt_MaPin.Text.Trim().Substring(0,4);
DateTime now = DateTime.Today;
DateTime answer = now.AddDays(1);
string datenow_kq = now.ToString().Replace("12:00:00 SA", "");
string datenext = answer.ToString().Replace("12:00:00 SA", "");
DataTable pxn_timenow = new DataTable();
pxn_timenow = pxnBSO.Get_PXN_Date_Now(datenow_kq, datenext);
if (pxn_timenow.Rows.Count > 0)
{
string kq_datenow = ConvertDate(datenow_kq);
string maphieu = pxn_timenow.Rows[0]["MaPhieu"].ToString();
string kq_maphieu = kq_datenow + (Convert.ToUInt32(maphieu.Substring(8)) + 1);
Medi_pxn.MaPhieu = kq_maphieu;
}
else
{
string kq_datenow = ConvertDate(datenow_kq);
string kq_maphieu = kq_datenow + "1";
Medi_pxn.MaPhieu = kq_maphieu;
}
Medi_pxn.CreateDate = DateTime.Now;
Medi_pxn.State = 0;
Medi_pxn.Language = Language.language;
return Medi_pxn;
}
public void Createpxn(Medi_PhieuXetNghiem pxn)
{
new Medi_PhieuXetNghiemDAO().CreatePhieuXetNghiem(pxn);
}
