public bool KhamBenhUpDate(KhamBenhEntity obj) { var khDAL = new KhamBenhDAL(); if (khDAL.KhamBenhUpDate(obj)) return true; return false; }
public bool KhamBenhInsert(KhamBenhEntity obj) { try { SqlConnection conn = ConnectionDB.GetConnect(); conn.Open(); SqlCommand cmd = new SqlCommand("KhamBenhInsert", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaKhamBenh", obj.MaKhamBenh)); cmd.Parameters.Add(new SqlParameter("@TenBacSi", obj.TenBacSi)); cmd.Parameters.Add(new SqlParameter("@MaBenhNhan", obj.MaBenhNhan)); cmd.Parameters.Add(new SqlParameter("@TenNguoiNhapLieu", obj.TenNguoiNhapLieu)); cmd.Parameters.Add(new SqlParameter("@ThoiGianKham", obj.ThoiGianKham)); cmd.Parameters.Add(new SqlParameter("ChuanDoan", obj.ChuanDoan)); cmd.Parameters.Add(new SqlParameter("@TrieuChung", obj.TrieuChung)); cmd.ExecuteNonQuery(); conn.Close(); } catch { return false; } return true; }
KhamBenhEntity NewKhamBenh() { KhamBenhEntity obj = new KhamBenhEntity(); obj.MaKhamBenh = txtMaKhamBenh.Text; obj.MaBenhNhan = lblMaBN.Text; obj.TenBacSi = txtBacSiKham.Text; obj.ThoiGianKham = dtNgayKham.Value; obj.TrieuChung = txtTrieuChung.Text; obj.ChuanDoan = txtChuanDoan.Text; obj.TenNguoiNhapLieu = txtNguoiNhap.Text; return obj; }