C# (CSharp) GetRoomDetailsBO Examples

Example #1

File: Receptionist_GetRoomDetailsBL.cs Project: devangsinha/Hospital-Management-System

    public DataSet GetRoomDetails(int wardId, int wardNumber)
    {
        GetRoomDetailsBO objGetRoomDetailsBO = new GetRoomDetailsBO();
        objGetRoomDetailsBO.wardId = wardId;
        objGetRoomDetailsBO.wardNumber = wardNumber;

        GetRoomDetailsDL objGetRoomDetailsDL = new GetRoomDetailsDL();
        return objGetRoomDetailsDL.GetRoomDetails(objGetRoomDetailsBO);
    }

Example #2

    public DataSet GetRoomDetails(int wardId, int wardNumber)
    {
        GetRoomDetailsBO objGetRoomDetailsBO = new GetRoomDetailsBO();

        objGetRoomDetailsBO.wardId     = wardId;
        objGetRoomDetailsBO.wardNumber = wardNumber;

        GetRoomDetailsDL objGetRoomDetailsDL = new GetRoomDetailsDL();

        return(objGetRoomDetailsDL.GetRoomDetails(objGetRoomDetailsBO));
    }

Example #3

File: GetRoomDetailsDL.cs Project: devangsinha/Hospital-Management-System

 public DataSet GetRoomDetails(GetRoomDetailsBO objGetRoomDetailsBO)
 {
     SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
     SqlCommand cmd = new SqlCommand("spGetRoomDetails", conn);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.Add("@wardId", objGetRoomDetailsBO.wardId);
     cmd.Parameters.Add("@wardNumber", objGetRoomDetailsBO.wardNumber);
     DataSet ds = new DataSet();
     SqlDataAdapter adapter = new SqlDataAdapter(cmd);
     conn.Open();
     adapter.Fill(ds);
     conn.Close();
     return ds;
 }

Example #4

File: GetRoomDetailsDL.cs Project: weddingjuma/Hospital-Management-System

    public DataSet GetRoomDetails(GetRoomDetailsBO objGetRoomDetailsBO)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand    cmd  = new SqlCommand("spGetRoomDetails", conn);

        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@wardId", objGetRoomDetailsBO.wardId);
        cmd.Parameters.Add("@wardNumber", objGetRoomDetailsBO.wardNumber);
        DataSet        ds      = new DataSet();
        SqlDataAdapter adapter = new SqlDataAdapter(cmd);

        conn.Open();
        adapter.Fill(ds);
        conn.Close();
        return(ds);
    }