public IPDetailModel GetIpDetailsFromIpNo(int xIpNo)
{
IPDetailModel model = new IPDetailModel();
using (connection = new MySqlConnection(conString))
{
string xQry = "select p.patient_id,p.patient_name,p.patient_address," +
"ip.room_id,doctor_id,case_type_id from " +
" ip_admission ip, " +
" m_patient_registration p " +
" where " +
" p.patient_id = ip.patient_id " +
" and ip.ipno = " + xIpNo + "";
connection.Open();
MySqlCommand comm = new MySqlCommand(xQry, connection);
MySqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
model = new IPDetailModel()
{
PatientId = Convert.ToInt32(reader.GetInt32(0)),
PatientName = reader.GetString(1),
PatientAddress = reader.GetString(2),
RoomId = reader.GetInt32(3),
DoctorId = reader.GetInt32(4),
CaseTypeId = reader.GetInt32(5)
};
}
connection.Close();
}
return(model);
}
private void cmbIPNo_SelectedIndexChanged(object sender, EventArgs e)
{
IPDetailModel ipResponse = xDb.GetIpDetailsFromIpNo(Convert.ToInt32(cmbIPNo.Text));
PatientResponseModel patientResponse = xDb.GetPatientFromPatientId(ipResponse.PatientId);
DoctorResponseModel doctorResponse = xDb.GetDoctorFromDoctorId(ipResponse.DoctorId);
txtPatientName.Text = patientResponse.PatientName.ToString();
txtDoctorName.Text = doctorResponse.DoctorName;
txtCaseType.Text = xDb.GetCaseTypeNameFromCaseTypeId(ipResponse.CaseTypeId);
}
private void cmbIPNo_SelectedIndexChanged(object sender, EventArgs e)
{
DataClear();
IPDetailModel result = xDb.GetIpDetailsFromIpNo(Convert.ToInt32(cmbIPNo.Text));
lblPatientName.Text = result.PatientName.ToString();
lblAddress.Text = result.PatientAddress.ToString();
txtAdvance.Text = xDb.GetAdvancePaymentFromIpNo(Convert.ToInt32(cmbIPNo.Text));
LoadAdvanceGrid();
}
private void cmbIPNo_SelectedIndexChanged(object sender, EventArgs e)
{
DataClear();
IPDetailModel result = xDb.GetIpDetailsFromIpNo(Convert.ToInt32(cmbIPNo.Text));
lblPatientId.Text = lblPatientId.Text + " : " + result.PatientId.ToString();
lblPatientName.Text = lblPatientName.Text + " : " + result.PatientName.ToString();
//lblPatientAddress.Text = lblPatientAddress.Text + " : " + result.PatientAddress.ToString();
lblTotalAdvancePaid.Text = xDb.GetAdvancePaymentFromIpNo(Convert.ToInt32(cmbIPNo.Text));
lblRoomId.Text = lblRoomId.Text + " : " + result.RoomId.ToString();
}
