public int Doctor_IPDDoctorTransfer(string transferDate, string transferTime, string reasonForTransfer,
        int transferToDoctorId, int transferByDoctorId, int patientId)
    {
        Doctor_IPDDoctorTransferBO objDoctor_IPDDoctorTransferBO = new Doctor_IPDDoctorTransferBO();
        objDoctor_IPDDoctorTransferBO.transferDate = transferDate;
        objDoctor_IPDDoctorTransferBO.transferTime = transferTime;
        objDoctor_IPDDoctorTransferBO.reasonForTransfer = reasonForTransfer;
        objDoctor_IPDDoctorTransferBO.transferByDoctorId = transferByDoctorId;
        objDoctor_IPDDoctorTransferBO.transferToDoctorId = transferToDoctorId;
        objDoctor_IPDDoctorTransferBO.patientId = patientId;

        Doctor_IPDDoctorTransferDL objDoctor_IPDDoctorTransferDL = new Doctor_IPDDoctorTransferDL();
        return objDoctor_IPDDoctorTransferDL.Doctor_IPDDoctorTransfer(objDoctor_IPDDoctorTransferBO);
    }
Ejemplo n.º 2
0
    public int Doctor_IPDDoctorTransfer(string transferDate, string transferTime, string reasonForTransfer,
                                        int transferToDoctorId, int transferByDoctorId, int patientId)
    {
        Doctor_IPDDoctorTransferBO objDoctor_IPDDoctorTransferBO = new Doctor_IPDDoctorTransferBO();

        objDoctor_IPDDoctorTransferBO.transferDate       = transferDate;
        objDoctor_IPDDoctorTransferBO.transferTime       = transferTime;
        objDoctor_IPDDoctorTransferBO.reasonForTransfer  = reasonForTransfer;
        objDoctor_IPDDoctorTransferBO.transferByDoctorId = transferByDoctorId;
        objDoctor_IPDDoctorTransferBO.transferToDoctorId = transferToDoctorId;
        objDoctor_IPDDoctorTransferBO.patientId          = patientId;

        Doctor_IPDDoctorTransferDL objDoctor_IPDDoctorTransferDL = new Doctor_IPDDoctorTransferDL();

        return(objDoctor_IPDDoctorTransferDL.Doctor_IPDDoctorTransfer(objDoctor_IPDDoctorTransferBO));
    }
    public int Doctor_IPDDoctorTransfer(Doctor_IPDDoctorTransferBO objDoctor_IPDDoctorTransferBO)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand cmd = new SqlCommand("sp_Doctor_IPDDoctorTransfer", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@transferDate", objDoctor_IPDDoctorTransferBO.transferDate);
        cmd.Parameters.Add("@transferTime", objDoctor_IPDDoctorTransferBO.transferTime);
        cmd.Parameters.Add("@reasonForTransfer", objDoctor_IPDDoctorTransferBO.reasonForTransfer);
        cmd.Parameters.Add("@transferToDoctorId", objDoctor_IPDDoctorTransferBO.transferToDoctorId);
        cmd.Parameters.Add("@transferByDoctorId", objDoctor_IPDDoctorTransferBO.transferByDoctorId);
        cmd.Parameters.Add("@patientId", objDoctor_IPDDoctorTransferBO.patientId);

        conn.Open();
        int doctorTransferId = Convert.ToInt32((cmd.ExecuteScalar()).ToString());
        conn.Close();
        return doctorTransferId;
    }
    public int Doctor_IPDDoctorTransfer(Doctor_IPDDoctorTransferBO objDoctor_IPDDoctorTransferBO)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand    cmd  = new SqlCommand("sp_Doctor_IPDDoctorTransfer", conn);

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@transferDate", objDoctor_IPDDoctorTransferBO.transferDate);
        cmd.Parameters.Add("@transferTime", objDoctor_IPDDoctorTransferBO.transferTime);
        cmd.Parameters.Add("@reasonForTransfer", objDoctor_IPDDoctorTransferBO.reasonForTransfer);
        cmd.Parameters.Add("@transferToDoctorId", objDoctor_IPDDoctorTransferBO.transferToDoctorId);
        cmd.Parameters.Add("@transferByDoctorId", objDoctor_IPDDoctorTransferBO.transferByDoctorId);
        cmd.Parameters.Add("@patientId", objDoctor_IPDDoctorTransferBO.patientId);

        conn.Open();
        int doctorTransferId = Convert.ToInt32((cmd.ExecuteScalar()).ToString());

        conn.Close();
        return(doctorTransferId);
    }