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);
    }
Exemple #2
0
    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;
    }
Exemple #4
0
    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);
    }