private void CapNhat()
{
try
{
KHAMDINHKI khamdinhki1 = GetKHAMDINHKIByForm();
KHAMCHUYENKHOA khamchuyenkhoa1 = GetKHAMCHUYENKHOAByForm();
KHAMCANLAMSANG khamcanlamsang1 = GetKHAMCANLAMSANGByForm();
KHAMTHELUC khamtheluc1 = GetKHAMTHELUCByForm();
khamdinhki1.ID = khamdinhki.ID;
khamdinhki1.KHAMCANLAMSANGID = khamdinhki.KHAMCANLAMSANGID;
khamdinhki1.KHAMTHELUCID = khamdinhki.KHAMTHELUCID;
khamdinhki1.KHAMCHUYENKHOAID = khamdinhki.KHAMCHUYENKHOAID;
khamchuyenkhoa1.ID = (int)khamdinhki.KHAMCHUYENKHOAID;
khamcanlamsang1.ID = (int)khamdinhki.KHAMCANLAMSANGID;
khamtheluc1.ID = (int)khamdinhki.KHAMTHELUCID;
KHAMDINHKIService.Update(khamdinhki1);
KHAMCHUYENKHOAService.Update(khamchuyenkhoa1);
KHAMCANLAMSANGService.Update(khamcanlamsang1);
KHAMTHELUCService.Update(khamtheluc1);
}
catch
{
}
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of KHAMCANLAMSANG</returns>
internal List <KHAMCANLAMSANG> PopulateObjectsFromReader(IDataReader dataReader)
{
List <KHAMCANLAMSANG> list = new List <KHAMCANLAMSANG>();
while (dataReader.Read())
{
KHAMCANLAMSANG businessObject = new KHAMCANLAMSANG();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(KHAMCANLAMSANG businessObject, IDataReader dataReader)
{
businessObject.ID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.ID.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.BACSIID.ToString())))
{
businessObject.BACSIID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.BACSIID.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.MAU.ToString())))
{
businessObject.MAU = dataReader.GetString(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.MAU.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.NUOCTIEU.ToString())))
{
businessObject.NUOCTIEU = dataReader.GetString(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.NUOCTIEU.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.SIEUAM.ToString())))
{
businessObject.SIEUAM = dataReader.GetString(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.SIEUAM.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.DIENTIM.ToString())))
{
businessObject.DIENTIM = dataReader.GetString(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.DIENTIM.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.XQUANG.ToString())))
{
businessObject.XQUANG = dataReader.GetString(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.XQUANG.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.XETNGHIEMKHAC.ToString())))
{
businessObject.XETNGHIEMKHAC = dataReader.GetString(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.XETNGHIEMKHAC.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.KETQUACANLAMSANG.ToString())))
{
businessObject.KETQUACANLAMSANG = dataReader.GetString(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.KETQUACANLAMSANG.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.GHICHU.ToString())))
{
businessObject.GHICHU = dataReader.GetString(dataReader.GetOrdinal(KHAMCANLAMSANG.KHAMCANLAMSANGFields.GHICHU.ToString()));
}
}
private KHAMCANLAMSANG GetKHAMCANLAMSANGByForm()
{
KHAMCANLAMSANG ans = new KHAMCANLAMSANG();
ans.BACSIID = (int)cbxBacSiCanLamSang.EditValue;
ans.MAU = txtCanLamSangMau.Text;
ans.NUOCTIEU = txtCanLamSangNuocTieu.Text;
ans.SIEUAM = txtCanLamSangSieuAm.Text;
ans.DIENTIM = txtCanLamSangDienTim.Text;
ans.GHICHU = txtTheLucGhiChu.Text;
ans.XQUANG = txtCanLamSangXQuang.Text;
ans.XETNGHIEMKHAC = txtCanLamSangXetNghiemKhac.Text;
ans.KETQUACANLAMSANG = txtCanLamSangKetQua.Text;
return(ans);
}
private void UpdateDetail()
{
try
{
UpdateDetailKhamDinhKi(khamdinhki);
KHAMCHUYENKHOA khamchuyenkhoa = KHAMCHUYENKHOAService.GetByPrimaryKey(new KHAMCHUYENKHOAKeys((int)khamdinhki.KHAMCHUYENKHOAID));
KHAMCANLAMSANG khamcanlamsang = KHAMCANLAMSANGService.GetByPrimaryKey(new KHAMCANLAMSANGKeys((int)khamdinhki.KHAMCANLAMSANGID));
KHAMTHELUC khamtheluc = KHAMTHELUCService.GetByPrimaryKey(new KHAMTHELUCKeys((int)khamdinhki.KHAMTHELUCID));
UpdateDetailKhamChuyenKhoa(khamchuyenkhoa);
UpdateDetailKhamCanLamSang(khamcanlamsang);
UpdateDetailKhamTheLuc(khamtheluc);
}
catch
{
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
try
{
if (CheckKhamDinhKi())
{
KHAMDINHKI khamdinhki1 = GetKHAMDINHKIByForm();
KHAMCHUYENKHOA khamchuyenkhoa = GetKHAMCHUYENKHOAByForm();
KHAMCANLAMSANG khamcanlamsang = GetKHAMCANLAMSANGByForm();
KHAMTHELUC khamtheluc = GetKHAMTHELUCByForm();
if (khamdinhki.ID == 0)
{
KHAMCHUYENKHOAService.Insert(khamchuyenkhoa);
KHAMCANLAMSANGService.Insert(khamcanlamsang);
KHAMTHELUCService.Insert(khamtheluc);
khamdinhki1.KHAMCHUYENKHOAID = khamchuyenkhoa.ID;
khamdinhki1.KHAMTHELUCID = khamtheluc.ID;
khamdinhki1.KHAMCANLAMSANGID = khamcanlamsang.ID;
KHAMDINHKIService.Insert(khamdinhki1);
MessageBox.Show("Thêm thông tin khám định kì thành công",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
LockControl();
}
else
{
CapNhat();
MessageBox.Show("Cập nhật thông tin khám định kì thành công",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
UpdateDetail();
}
}
catch
{
}
}
private void UpdateDetailKhamCanLamSang(KHAMCANLAMSANG khamcanlamsang)
{
try
{
cbxBacSiCanLamSang.EditValue = khamcanlamsang.BACSIID;
txtCanLamSangMau.Text = khamcanlamsang.MAU;
txtCanLamSangXQuang.Text = khamcanlamsang.XQUANG;
txtCanLamSangNuocTieu.Text = khamcanlamsang.NUOCTIEU;
txtCanLamSangXetNghiemKhac.Text = khamcanlamsang.XETNGHIEMKHAC;
txtCanLamSangSieuAm.Text = khamcanlamsang.SIEUAM;
txtCanLamSangDienTim.Text = khamcanlamsang.DIENTIM;
txtCanLamSangKetQua.Text = khamcanlamsang.KETQUACANLAMSANG;
txtCanLamSangGhiChu.Text = khamcanlamsang.GHICHU;
}
catch
{
}
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>KHAMCANLAMSANG business object</returns>
public KHAMCANLAMSANG SelectByPrimaryKey(KHAMCANLAMSANGKeys keys)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[KHAMCANLAMSANG_SelectByPrimaryKey]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.ID));
MainConnection.Open();
IDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
KHAMCANLAMSANG businessObject = new KHAMCANLAMSANG();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch //(Exception ex)
{
return(null); //throw new Exception("KHAMCANLAMSANG::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(KHAMCANLAMSANG businessObject)
{
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "dbo.[KHAMCANLAMSANG_Insert]";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ID));
sqlCommand.Parameters.Add(new SqlParameter("@BACSIID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BACSIID));
sqlCommand.Parameters.Add(new SqlParameter("@MAU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.MAU));
sqlCommand.Parameters.Add(new SqlParameter("@NUOCTIEU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.NUOCTIEU));
sqlCommand.Parameters.Add(new SqlParameter("@SIEUAM", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.SIEUAM));
sqlCommand.Parameters.Add(new SqlParameter("@DIENTIM", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DIENTIM));
sqlCommand.Parameters.Add(new SqlParameter("@XQUANG", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.XQUANG));
sqlCommand.Parameters.Add(new SqlParameter("@XETNGHIEMKHAC", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.XETNGHIEMKHAC));
sqlCommand.Parameters.Add(new SqlParameter("@KETQUACANLAMSANG", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.KETQUACANLAMSANG));
sqlCommand.Parameters.Add(new SqlParameter("@GHICHU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GHICHU));
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.ID = (int)sqlCommand.Parameters["@ID"].Value;
return(true);
}
catch //(Exception ex)
{
return(false); //throw new Exception("KHAMCANLAMSANG::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
