public int DL_InsUpdPatientAdmission(ML_Patient objML_Patient)
{
SqlParameter[] par = { new SqlParameter("@AdmissionNo", objML_Patient.AdmissionNo),
new SqlParameter("@AdmissionDate", objML_Patient.AdmissionDate),
new SqlParameter("@FirstName", objML_Patient.FirstName),
new SqlParameter("@LastName", objML_Patient.LastName),
new SqlParameter("@DOB", objML_Patient.DOB),
new SqlParameter("@Gender", objML_Patient.Gender),
new SqlParameter("@MarriedStatus", objML_Patient.MarriedStatus),
new SqlParameter("@Age", objML_Patient.Age),
new SqlParameter("@PhoneNo", objML_Patient.PhoneNo),
new SqlParameter("@MobileNo", objML_Patient.MobileNo),
new SqlParameter("@EmailID", objML_Patient.EmailID),
new SqlParameter("@MadicineInformation", objML_Patient.MadicineInformation),
new SqlParameter("@HospitalName", objML_Patient.HospitalName),
new SqlParameter("@Doctor", objML_Patient.Doctor),
new SqlParameter("@Bed", objML_Patient.Bed),
new SqlParameter("@Ward", objML_Patient.Ward),
new SqlParameter("@Address", objML_Patient.Address),
new SqlParameter("@City", objML_Patient.City),
new SqlParameter("@State", objML_Patient.State),
new SqlParameter("@Amount", objML_Patient.Amount),
new SqlParameter("@Department", objML_Patient.Department),
new SqlParameter("@CreatedBy", objML_Patient.CreatedBy),
new SqlParameter("@ModifyBy", objML_Patient.ModifyBy),
new SqlParameter("@BillType", objML_Patient.BillType),
new SqlParameter("@Charges", objML_Patient.Charges),
new SqlParameter("@Complient", objML_Patient.Compilent) };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpdPatientAdmission", par));
}
public int DL_InsUpdToken(ML_Patient objML_Patient)
{
SqlParameter[] par = { new SqlParameter("@TokenID", objML_Patient.ID),
new SqlParameter("@ApplicantName", objML_Patient.FirstName),
new SqlParameter("@Slip_No", objML_Patient.AppointmentNo),
new SqlParameter("@CreatedBy", objML_Patient.CreatedBy),
new SqlParameter("@ModifyBy", objML_Patient.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_Insert_Token", par));
}
public int DL_InsUpdUserAppointment(ML_Patient objML_Patient)
{
SqlParameter[] par = { new SqlParameter("@AppointmentNo", objML_Patient.AppointmentNo),
new SqlParameter("@AppointmentDate", objML_Patient.AppointmentDate),
new SqlParameter("@FirstName", objML_Patient.FirstName),
new SqlParameter("@LastName", objML_Patient.LastName),
new SqlParameter("@W_D_F_Name", objML_Patient.W_D_F_Name),
new SqlParameter("@Gender", objML_Patient.Gender),
new SqlParameter("@DOB", objML_Patient.DOB),
new SqlParameter("@MobileNo", objML_Patient.MobileNo),
new SqlParameter("@Address", objML_Patient.Address),
new SqlParameter("@City", objML_Patient.City),
new SqlParameter("@State", objML_Patient.State),
new SqlParameter("@Amount", objML_Patient.Amount),
new SqlParameter("@Doctor", objML_Patient.Doctor),
new SqlParameter("@CreatedBy", objML_Patient.CreatedBy),
new SqlParameter("@ModifyBy", objML_Patient.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpdUserAppointment", par));
}
public int BL_InsUpdToken(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_InsUpdToken(objML_Patient));
}
public DataTable BL_BindHospital(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_BindHospital(objML_Patient));
}
public DataTable BL_EditPatient(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_EditPatient(objML_Patient));
}
public int BL_DeletePatient(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_DeletePatient(objML_Patient));
}
public DataTable BL_BindPaitent(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_BindPatient(objML_Patient));
}
public DataTable BL_SerachPatient(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_SearchPatient(objML_Patient));
}
public int BL_InsUpdPatientAdmission(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_InsUpdPatientAdmission(objML_Patient));
}
public int BL_InsUpdUserDetail(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_InsUpdUserAppointment(objML_Patient));
}
public DataTable DL_BindPatient(ML_Patient objML_Patient)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Patient.ID) };
return(SqlHelper.ExecuteDataset(con, "SPCN_BindPatientList", par).Tables[0]);
}
public DataTable DL_SelectAppointment(ML_Patient objML_Patient)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Patient.ID) };
return(SqlHelper.ExecuteDataset(con, "SPCN_Select_Appointment", par).Tables[0]);
}
public DataTable DL_DisplayToken(ML_Patient objML_Patient)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Patient.ID) };
return(SqlHelper.ExecuteDataset(con, "SPCN_Display_Token", par).Tables[0]);
}
public DataTable BL_BindToken(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_BindToken(objML_Patient));
}
public DataTable BL_Bindbed(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_BindBed(objML_Patient));
}
public DataTable BL_DisplayToken(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_DisplayToken(objML_Patient));
}
public DataTable BL_BindDepartment(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_BindDepartment(objML_Patient));
}
public DataTable BL_SelectAppointment(ML_Patient objML_Patient)
{
return(objDL_Patient.DL_SelectAppointment(objML_Patient));
}
public int DL_DeletePatient(ML_Patient objML_Patient)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_Patient.ID), };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_Patient_Delete", par));
}
