public int Doctor_AddIPDObservation(string ipdObservationId, int doctorId, int patientId, string observationDate, string observationTime, int patientHealthCondition, int transferToDoctorId, int wardTransferId) { Doctor_AddIPDObservationBO objDoctor_AddIPDObservationBO = new Doctor_AddIPDObservationBO(); objDoctor_AddIPDObservationBO.ipdObservationId = ipdObservationId; objDoctor_AddIPDObservationBO.doctorId = doctorId; objDoctor_AddIPDObservationBO.patientId = patientId; objDoctor_AddIPDObservationBO.observationDate = observationDate; objDoctor_AddIPDObservationBO.observationTime = observationTime; objDoctor_AddIPDObservationBO.patientHealthCondition = patientHealthCondition; objDoctor_AddIPDObservationBO.transferToDoctorId = transferToDoctorId; objDoctor_AddIPDObservationBO.wardTransferId = wardTransferId; Doctor_AddIPDObservationDL objDoctor_AddIPDObservationDL = new Doctor_AddIPDObservationDL(); return objDoctor_AddIPDObservationDL.Doctor_AddIPDObservation(objDoctor_AddIPDObservationBO); }
public int Doctor_AddIPDObservation(string ipdObservationId, int doctorId, int patientId, string observationDate, string observationTime, int patientHealthCondition, int transferToDoctorId, int wardTransferId) { Doctor_AddIPDObservationBO objDoctor_AddIPDObservationBO = new Doctor_AddIPDObservationBO(); objDoctor_AddIPDObservationBO.ipdObservationId = ipdObservationId; objDoctor_AddIPDObservationBO.doctorId = doctorId; objDoctor_AddIPDObservationBO.patientId = patientId; objDoctor_AddIPDObservationBO.observationDate = observationDate; objDoctor_AddIPDObservationBO.observationTime = observationTime; objDoctor_AddIPDObservationBO.patientHealthCondition = patientHealthCondition; objDoctor_AddIPDObservationBO.transferToDoctorId = transferToDoctorId; objDoctor_AddIPDObservationBO.wardTransferId = wardTransferId; Doctor_AddIPDObservationDL objDoctor_AddIPDObservationDL = new Doctor_AddIPDObservationDL(); return(objDoctor_AddIPDObservationDL.Doctor_AddIPDObservation(objDoctor_AddIPDObservationBO)); }
public int Doctor_AddIPDObservation(Doctor_AddIPDObservationBO objDoctor_AddIPDObservationBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("sp_Doctor_AddIPDObservation", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ipdObservationId", objDoctor_AddIPDObservationBO.ipdObservationId); cmd.Parameters.Add("@doctorId", objDoctor_AddIPDObservationBO.doctorId); cmd.Parameters.Add("@patientId", objDoctor_AddIPDObservationBO.patientId); cmd.Parameters.Add("@observationDate", objDoctor_AddIPDObservationBO.observationDate); cmd.Parameters.Add("@observationTime", objDoctor_AddIPDObservationBO.observationTime); cmd.Parameters.Add("@patientHealthCondition", objDoctor_AddIPDObservationBO.patientHealthCondition); cmd.Parameters.Add("@transferToDoctorId", objDoctor_AddIPDObservationBO.transferToDoctorId); cmd.Parameters.Add("@wardTransferId", objDoctor_AddIPDObservationBO.wardTransferId); conn.Open(); int ipdObservationId = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return ipdObservationId; }
public int Doctor_AddIPDObservation(Doctor_AddIPDObservationBO objDoctor_AddIPDObservationBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("sp_Doctor_AddIPDObservation", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ipdObservationId", objDoctor_AddIPDObservationBO.ipdObservationId); cmd.Parameters.Add("@doctorId", objDoctor_AddIPDObservationBO.doctorId); cmd.Parameters.Add("@patientId", objDoctor_AddIPDObservationBO.patientId); cmd.Parameters.Add("@observationDate", objDoctor_AddIPDObservationBO.observationDate); cmd.Parameters.Add("@observationTime", objDoctor_AddIPDObservationBO.observationTime); cmd.Parameters.Add("@patientHealthCondition", objDoctor_AddIPDObservationBO.patientHealthCondition); cmd.Parameters.Add("@transferToDoctorId", objDoctor_AddIPDObservationBO.transferToDoctorId); cmd.Parameters.Add("@wardTransferId", objDoctor_AddIPDObservationBO.wardTransferId); conn.Open(); int ipdObservationId = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(ipdObservationId); }